Dakshesh Keni
Summary
• More than Seven years of Industry experience in software design, development
and implementation of various Client Server applications.
• Extensive experience in Database design and development of applications using
SQL Server 2000/2005/2008, Integration Services (SSIS), Reporting Services 2005
(SSRS), SQL Server Analysis Services (SSAS),MDX queries, OLAP Cubes, Star schema
and Snow flake schema
• Expertise in Object Oriented, Web applications, .NET Framework ASP.NET, C#,
VB.NET, ADO.NET, Visual Studio.NET, Visual Basic, Visual Interdev, ActiveX
Controls, Active Server Pages (ASP), XML, Java, JavaScript, COM / COM+ / DCOM
• Excellent understanding of full Software Development Life Cycle (SDLC)
• Highly motivated with excellent analytical and communication skills and an
ability to learn new systems and Business procedures
• Expertise in creating applications for Business like Manufacturing,
Telecommunications, Mortgage, Finance, Insurance, Sales and Marketing
• Well versed in UML software's like Visual Paradigm, Visio 2000, Rational Rose
and Smart Draw methodology for documentation and communication
• Ability to work independently with a high degree of personal initiative.
Technical Skills
Languages: VB, VB.NET, VB Script, VBA, C, C#, Java, JavaScript, UML, XSL,
SQL, FoxPro
Web Technology: ASP, ASP.NET, XML, XSLT, IIS 5.0/4.0, CSS, JRun, HTML,
DHTML, Web Services
GUI Tools/IDE: Visual Studio.NET, Visual Studio 5.0/6.0, Visual Interdev
6.0, Data Junction 7.5/7.5.5/ 8.0
RDBMS: MS SQL Server 2000, 2005, 2008 Oracle 8i/9i, MS Access
97/2000
Project Mgt. Tools: Rational Suite Products, Visio 2000, Microsoft Project
Manager, Visual Paradigm
Operating System: Windows XP, Windows 2000 Server, Windows NT/95, Unix, DOS
Middleware: COM/DCOM/COM+, ADO.NET, ADO.NET, ODBC, Win32 API, JDBC,
Active-X Controls
Version Control: Visual Source Safe 6.0, Harvest, Documentum
Reporting Tools: Active Reports, Crystal Reports 4.5/5.0/8.5/9.0, SQL
Reporting services 2000/2005/2008
UML Diagrams: Use Cases, System Sequence Diagrams, Class Diagrams,
Collaboration Diagrams, State Diagrams and Activity Diagrams
Professional Experience
Georgia-Pacific
Atlanta, GA
Sr. SQL Server Developer/ BI Developer
Sept 08 – Present
OLARIS – (On Line Analytical Reporting Information System) This application
displays various reports. Management Reports like Consolidated, P&L, Consumer
Products, Businesses, MTD, YTD, and Per Unit etc. Income Variance Reports like
P&L IVA Comparison vs. Prior Quarter, Prior Month, and Prior year. Critical
business data like Finished Goods Volume, Gross Revenue, Reported Sales Rebates,
Customer Allowance Programs, and etc. all the data is compared with actual and
planned with prior Quarter, Month etc. assisting to forecast and analyze future
operations.
Responsibilities:
• Designed and developed databases for financial applications using SQL Server
2000/2005
• Created stored procedures, views, tables, triggers, table-valued, scalar
functions etc. on various databases for critical data involving profit and loss,
net revenue, forecasting etc.
• Complex procedures were created as they involved in gathering and aggregating
data from various tables and databases using multiple joins giving me an
excellent experience to create most complex queries.
• SQL was written is such a way that it can be easily reused and maintained for
future projects
• Created DLL’s to be exposed to development, staging and production servers
• Involved in performance tuning, query optimization, applications testing,
processes enhancement, and documentation.
• Created ASP.Net applications using VB.NET/C# to display the reports and handle
navigations.
• VSS was used for version control on reports as well as database objects.
• Performed unit testing of reports on QA databases
• Involved in getting approvals on the tasks completed
• Always met time lines by finishing tasks before they were due
Environment:
MS SQL Server 2000/2005, T-SQL, Active Reports, ASP.NET, ADO.NET, Visual
Studio.NET
AT&T
Atlanta, GA
Sr. SQL Server / BI Developer
Jan 08 – Sept 08
NCS Scorecard – This application displays scorecard type information for various
department. Information is categorized in different groups and measures. Data is
then compared with the predefined goals and the scorecard is calculated.
ADMIT – It is an Agent management system that allows functionality to add,
promote, and remove Agents for Meta data.
Call Allocator – It is a system to allocate time slots and call routing to
various different call centers around the globe.
Responsibilities:
• Created and modified tables, views, indexes, procedures, triggers, functions
in SQL Server 2005.
• Tuned queries, stored procedures to enhance the performance of applications.
• Created SQL Server Integration Service (SSIS) packages to export and import
data from various source systems to SQL Server.
• Used most of the tools in SSIS packages like looping, data formatting, error
handling, email notification, Web service task, etc.
• SSIS Packages were developed to extract/transform data, develop Business
Intelligence
• Created and Scheduled daily and bi-weekly SQL jobs for maintenance and file
processings.
• Extensively utilized SSIS packages functionality to create complete ETL
process using scripts, stored procedure, functions, transformation of data etc.
• Worked with Application Developers to support Development activities and
achieve optimal efficiency.
• Monitored space usage and scheduled existing/new jobs on production
environment.
• Used Visual SourceSafe to keep trace of version of store procedures.
• Responsible for keeping system and databases up-to-date by making necessary
changes.
• Created stored procedures, views, triggers, and built custom user defined
functions.
• Designed Databases, stored procedures, tables, views, triggers, SQL functions
in SQL 2000 and SQL 2005
• Various types of reports (Drill down, Matrix, and Navigating) with charts were
created using SQL Reporting Services 2005 (SSRS), Crystal Reports.
• ASP.Net applications using VB.NET/C# were created for front end.
• Setting up database backup and recovery for production, quality and
development servers.
• Promoted and tested SQL code in testing environment.
• Managed database security, created and assigned appropriate roles and
privileges to users.
Environment:
MS SQL Server 2005, SSIS, T-SQL, SQL Reporting Services 2005, ASP.NET, ADO.NET,
Visual Studio.NET, SharePoint 2003
BellSouth Telecommunications
Atlanta, GA
Sr. SQL Server / BI Developer
Nov 05 – Dec 07
PDR - (Performance Data Reports) this application displays day to day
performance reports for Managers, Supervisors and Employees based on their
performance. Performances are based on the number calls handled by the employees
at different call centers throughout US. It processes data from various source
systems like WFA, TAFI and LMOS.
Responsibilities:
• Proposed various change requests to enhance the functionality and stability of
the existing system. These changes resulted in saving the department thousands of
dollars.
• Successfully ensured quality Work products by conducting multiple qualities
check points prior to the deployment and delivery phases.
• Obtained user approvals from the client for the collected requirements to
ensure similar understanding between development team and business.
• Complete hierarchy was created from General Manager to Employee level, to be
utilized throughout the applications.
• Implemented configuration management in the project by implementing VSS.
• Proactively proposed, designed and developed various application enhancements,
thus eliminating redundant tasks and tickets and saving more than $100,000 a
year.
• Created stored procedures, views, triggers, and built custom user defined
functions.
• Designed Databases, stored procedures, tables, views, SQL functions in SQL
2000 and SQL 2005
• Various types of reports (Drill down, Matrix, and Navigating) with charts were
created using Reporting Services 2005, Crystal reports.
• Reports were scheduled to be executed and sent to client via email and posted
on Share point Server.
• Created views in Share point modified web parts uploaded new documents and
customized the existing Share point site.
• Created ASP.Net applications using VB.NET/C# for front end.
• Created Windows Service using ASP.Net, VB.NET/C# to massage files when they
arrive before processing.
• Extensively utilized SSIS packages functionality to create complete ETL
process using scripts, stored procedure, functions, transformation of data etc.
• Created SQL jobs to process files, execute SSIS packages and publish data on
the web server.
• Retrieved data from Web service, creating an XML file and utilized it in
packages for further processing.
• Involve in performance tuning to optimize existing applications and
processes.
• Implemented applications by following complete SDLC process.
• Supported applications by rerunning previous files, handled queries, and
created ad-hoc reports as requested
• DLL was created to color different groups that were used in the reports.
• Matrix reports were created for the report whose columns were not
predetermined.
• Various user defined functions were created to reuse in reports and store
procedure.
• Performed Database recovery at a table level using Lite Speed.
• Managed database security, created and assigned appropriate roles and
privileges to users.
• Created database backup and recovery using Lite Speed scripts and also MS-SQL
scripts.
• ASP.NET application were created using .NET framework, C#, VB.NET utilizing
ADO.NET for Data connections.
Environment:
MS SQL Server 2005, SSIS, T-SQL, SQL Reporting Services 2005, ASP.NET, ADO.NET,
Visual Studio.NET, SharePoint 2003
Accenture
Atlanta, G |
