Dakshesh Keni (Kenny)

trmv79@r.postjobfree.com

404-***-****

SUMMARY:

• More than Eight 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, Data mart, 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, Visual Script, 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 Banking/Investment, Manufacturing, Telecommunications, Mortgage, Finance, Insurance, Sales and Marketing

• Well versed in UML software's like Visual Paradigm, Visio 2005, Rational Rose and Smart Draw methodology for documentation and communication

• Ability to work independently with a high degree of personal initiative.

• Highly experienced with Eagle Pace data management PACE/STAR investment accounting and performance measurement tools and technologies to design and create Uploaders, Exporters, scheduling jobs, creating/deployment .egl files from different environments, troubleshooting fallouts.

EDUCATION:

• University of New Haven, CT

o Masters in Computer Science

• University of Bombay, India

o Bachelor in Business Administration

SKILLS:

• Languages: VB, VB.NET, VB Script, VBA, C, C#, Java, JavaScript, Perl Scripting, 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 2005/2008, Visual Studio 5.0/6.0, Visual Interdev 6.0, Data Junction 7.5/7.5.5/ 8.0

• RDBMS: Eagle PACE/STAR 7.0/9.0/10.0, MS SQL Server 2000, 2005, 2008 Oracle 8i/9i, MS Access 2005/2007

• Project Mgt. Tools: SharePoint 2007, Rational Suite Products, Visio, Microsoft Project Manager, Visual Paradigm

• Operating System: Window 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: Team Foundation Sever (TFS) Visual Source Safe, 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

EXPERIENCE:

03/09 - Present

ING, Atlanta, GA

Senior EAGLE PACE Developer

Eagle PACE – Eagle Investment Systems provides leading-edge data management, investment accounting and performance measurement solutions and professional services to support the global financial services industry. Integrated ING Data warehouse systems with internal systems like Accounting, Trading, Portfolio Management, Treasury, and Strategy etc. external systems like BlackRock, Charles River, BNY Mellon (Liquidity Direct, Short Term Money Market Trades) and JP Morgan

• Created requirement documents including schema and data mapping for uploaders and exporters by working with Business Users

• Worked on data verification, testing data plan preparation, source data extraction designs, data profiling, data model validation, parallel testing scenarios. Participated in discussions with Business Users to fulfill their requirements.

• Designed and implemented rigorous systems lifecycle processes including design templates, QA check points, testing methodologies, and business acceptance processes.

• Created Uploaders to import data from different interfaces and move data between environments

• Record level Uploaders were created for uploading securities and trades data and batch level were created for uploading positions and performance data.

• Used Data Steward to support Uploaders and Exporters, monitoring components in PACE, schedule events, monitor feeds, send e-mail notifications upon event completions or failures, set up translations for uploaders and reporting purposes, set up the metadata, security functions in PACE like add a user, set up business groups and configure server settings.

• Created schema, events, schedules to manage PACE/STAR components. Scheduled Uploaders and Exporters to run on a regular basis using the Define Event tab in the Data Steward. Dependencies were set up between different events (e.g. do not allow position uploader run until security uploader has completed).

• Involved in assisting migration from Eagle PACE 9.0 version to 10.0.

• Used Import/Export Explorer tool in the PACE/STAR Administrator to migrate the interfaces, feed types, pace_fields, codes, code_values, code_translations, edits, and pace_inv_fields. Worked with Unique Identifiers to validate, add, correct, sync.

• Designed and created jobs using TIDAL job scheduler, scheduled jobs, created calendar, actions, events, variables etc.

• Created SOX (Sarbanes-Oxley) compliant SSIS packages along with other complex SSIS packages to Extract, Transform and Load data. Insured correctness, completeness and accuracy of data input/output.

• Used various functionalities like data flow task, file system task, fuzzy lookup, merge join, multicast, row count, script component, union all, pivot, unpivot, sort, derived column.

• Designed and developed Databases, created complex stored procedures, view, triggers, cursors, Pivot, Unpivot functions, CTE’s.

• Various types of reports (Drill down, Matrix, and Navigating) with charts were created using SQL Reporting Services (SSRS) 2005/2008.

• Involved DBA functions like Performance tuning, monitoring, query optimization, indexing, backup and recovery, replication, log shipping.

• Supported various existing applications by being on call as a backup for production support team.

Environment: Eagle PACE/STAR 7.0/9.0/10.0, MS SQL Server 2005/2008, T-SQL, SSIS, SSRS, SSAS, Visual Studio 2005/2008, VB.NET, C#, TIDAL, EAGLE PACE, TFS, SharePoint 2005/2007

09/08 – 03/09

GEORGIA-PACIFIC, Atlanta, GA

Senior SQL Server/BI Developer

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. 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, all the data is compared with actual and planned with prior Quarter, Month assisting to forecast and analyze future operations.

• Designed and developed databases for financial applications using SQL Server 2000/2005

• Created stored procedures, partitioned views, tables, triggers, table-valued, scalar functions on various databases for critical data involving profit and loss, net revenue, forecasting.

• 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 SSIS packages to perform ETL task of Consumer goods from various data sources like Oracle, text files, excel files, SQL Server and reporting data.

• 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

01/08 – 09/08

AT&T, Atlanta, GA

Senior SQL Server/BI Developer

NCS Scorecard – This application displays scorecard type information for various departments. 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.

• 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.

• SSIS Packages were developed to extract/transform data, develop Business Intelligence.

• Created and Scheduled daily and bi-weekly SQL jobs for maintenance and file processing.

• Utilized SSIS packages functionality to create complete ETL process using scripts, stored procedure, functions, transformation of data.

• Worked with Application Developers to support Development activities and achieve optimal efficiency.

• Monitored space usage and scheduled existing/new jobs on production environment.

• Built Cubes, created .MDX expressions for cube calculations.

• 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.

• Created views, dashboards pages, web parts on SharePoint and deployed SSRS reports to this portal.

• Set 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

11/05 – 12/07

BELLSOUTH TELECOMMUNICATIONS, Atlanta, GA

Senior SQL Server/BI Developer

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.

• Proposed various change requests to enhance the functionality and stability of the existing system. These changes resulted in saving the department thousands of dollars.

• 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.

• Completed hierarchy was created from General Manager to Employee level, to be utilized throughout the applications.

• Implemented configuration management in the project by implementing VSS.

• 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.

• Utilized SSIS packages functionality to create complete ETL process using scripts, stored procedure, functions, transformation of data.

• 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.

• Involved 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

04/04 – 11/05

ACCENTURE, Atlanta, GA

Senior SQL Server Developer

MORRIS (Mechanized Order Retrieval and Reporting Information System) this application receives affiliate service orders and service order activity from external data sources such as BellSouth Entertainment, BellSouth.net, BellSouth Wireless, and BellSouth Cellular Corp. MORRIS processes these files, updates its database with new data, creates reports positing them on MORRIS Reporting Website, and sends new generated files to REX (UNIX Server).

• Designed and developed databases for applications in SQL Server 2000.

• Created Web pages using ASP.NET to displaying reports and allowed functionalities like logins, searches.

• Application were developed with .NET Framework involving ASP.NET, VB.NET, and ADO.NET.

• Modified previously created application in VB.NET to handle new set of data coming into MORRIS.

• Replication functionality of SQL 2000 was utilized to make replica of Database tables to insure reporting database always had current data.

• SQL Server 2000 was extensively used for creating stored procedures, triggers, DTS packages.

• Created, scheduled SQL jobs to run import, export and reporting applications.

• Updated UNIX scripts, updated Crontab to change scripts execution schedule.

• Completed Software Development life cycle was followed. Analysis, Design, Construction, Testing and Implementation.

• Documentum, Harvest applications and Visual Source Safe were used for document storage and version control.

• Interacted with Clients to handle their day to day requirements End User Support, Production Support.

• Entire Sarbanes Oxley compliance process was incorporated before implementation of projects.

Environment: MS SQL Server 2000, T-SQL, SQL Reporting Services, Event Viewer, UNIX, ASP.NET, ADO.NET, Visual Studio.NET

09/03 – 04/04

HOME STAR MORTGAGE, Atlanta, GA

Senior SQL Server Developer

Home Star Mortgage is fastest growing Mortgage Company engaged in retail and wholesale home financing or refinancing. The application was to develop Windows Service in C# to automate a Secured FTP File Transfer. Once the data was retrieved it was converted into a .CSV File with proper formatting and sent to client everyday at a particular time. Email notification was send as confirmation.

• Designed Sequence diagrams, Use Cases, Class diagrams and data flow diagrams.

• Involved in designing the flow of project analyzed the time frame to complete the project.

• Microsoft Management Console was utilized to start, stop, continue, and pause the service.

• Involved in database release management processes and coordinating the maintenance of development, testing, and production environments.

• Stored procedures, views and triggers were developed to extract and update data.

• DTS was used in transformation of data from different data sources.

• Complex Inner and Outer joins were implemented to retrieve required data.

• Batch files were created to run the Secured FTP commands.

• Move It Freely Software was used to insure that the file is transferred on SSL Layer.

• Evaluated and recommended software and hardware components to improve database, data integrity, and application system performance.

• Setting up new and maintain existing backup and recovery strategies; database maintenance and performance tuning; and routine backup jobs and perform recovery as needed.

Environment: MS SQL Server 2000, T-SQL, Move It Freely Secured FTP, C#, Windows Service, MSI Installer, Event Viewer, Visio 2000, Visual Studio.NET, ASP.NET, ADO.NET.

Mass Mutual Financial

Stamford, CT Jan 03 – Sept 03

Sr. SQL Server Developer

Mass Mutual is a leading financial company. Their objective is to build, promote, and constantly innovating a diverse range of financial solutions tailored to the needs of our individual, corporate and institutional clients over the long term.

The application was to provide online access to users to their accounts whereby they could check their products, savings, benefit projections, account access, and information about investments.

Responsibilities:

• Utilized Visio 2000 for developing flowcharts, data flow diagrams of the modules developed, created UML diagrams like activity diagrams, Sequence diagrams, Use case diagrams etc.

• Responsible for the quality and integrity of data in the databases including creating; enhancing; and maintaining high performance; and high availability desktop tools.

• Business logic tiers and database applications related to the business, portfolio management, and accounting.

• Designed and develop SQL database for data layer using SQL Server 2000.

• Implemented Stored Procedures, Triggers, Joins, and Views in SQL at the backend levels.

• Involved in transformation of data from XML document to SQL Server 2000, Oracle using Data Junction 7.5.

• Produced test plans for Unit, Integration tests.

• Established and maintained database designs, firm-wide database strategy, performance tuning; query optimization, procedures, applications, processes, and documentation.

• In addition, developing and maintaining data export, as well as, transformation and load processes (ETL’s) for the Environment.

Environment:

Visual Studio.NET, MS SQL Server 2000, Oracle 9i, Microsoft Visio 2000, ASP.NET, ADO.NET, XML, Data Junction 7.5

Kemper Insurance

Stamford, CT Jan 02 - Dec 02

Software Developer

Kemper Insurance Corporation deals with both accounting and dental lines of business

System was to issue quotes and generate policies for dental. It also deals with cancellation and updating of policies

Responsibilities:

• Involved in heavy coding T-SQL, writing complex queries involving several tables.

• Created stored procedures, user defined functions, SQL Jobs etc.

• Designed DTS packages to query data and modify objects, and transforming data in/out of SQL Server 7.0 or SQL 2000.

• Designed and implemented several ASP.NET Web forms and controls for adding a new dentist / accountant and policy issuance with VB.NET.

• Developed Class modules for Database connectivity extensively using ADO.NET, VB.NET.

• Utilized existing COM components in ASP.NET applications to Add/Modify/View/Delete.

• Designed and implemented several C# components for policy cancellations and renewals for both dentists and accountants.

• Client side scripting was done exclusively with JavaScript.

• Designed and developed custom reports using Crystal Reports.

Environment:

VB.NET, C#, JavaScript, ASP.NET, ADO.NET, XML, Win32API, Web Services, Crystal Reports, Visual Studio.NET, MS SQL Server 2000, T-SQL, Visual Source Safe 6.0, Rational Rose (UML), IIS 5.0

Contact this candidate