SUMMARY:

• More than Seven years of experience in IT industry, involved in development and maintenances of software applications, C# and ASP.net applications, development using internet/intranet and client server application.
• Seven years of experience in Data Warehouse and Business Objects development.
• Proficient in building ETL packages and workflows using SSIS and Informatica.
• Expertise in designing reports using reporting tools like SSRS and good knowledge of Crystal reports.
• Skilled in building and deploying packages using Self Service Packaging and Deployment tool.
• Proficient in writing and tuning complex SQL, stored procedures and triggers in SQL Server.
• Expertise in development of Systems applications using C#, ASP.NET, ADO.NET and SQL Server.
• Skilled in development and implementation of class libraries for encapsulating large - scale business objects.
• Developed the Data Access Components using ADO.NET, Data Readers, Data Sets and SQL Server 2008/2012.
• Experienced in designing Win-Forms, User Controls and Web-Forms using C#.NET and ASP.NET.
• Major strengths are familiarity with multiple software systems, tools and the ability to learn quickly new technologies and adapt to new environments.

TECHNICAL SKILLS:

RDBMS: SQL Server 2008/2012, MS-Access

ETL Tools: SQL Server Integration Service 2008/2012, Informatica 8.1/8.6/9

Reporting Tools: SSRS 2008/2012, Crystal Reports 8.5

BI Technologies: Business Objects XI 3.1, BO .Net SDK

.Net Technologies: MS Visual Studio 2012,.NET Framework 3.5/4.0/4.5, C#.Net, ADO.Net, ASP.Net, Windows Services,Entity Framework

Web Technologies: HTML,DHTML, XML, Java Script, CSS

Platforms: Windows XP, 2003, NT, Windows 7

Source Control: SVN

Task/Issue Tracking Tool: Jira

Software Packaging Tool: Admin Studio

CMS: Umbraco 7.3

EXPERIENCE:

Confidential

Application Developer

Responsibilities:

• Designing DataWarehouse with user interface to provide facility for end users to load data into system without having technical knowledge using SQL Server 2012, SSIS, C# and .Net APIs.
• Working closly with Actuarial deparment on loading and analysis of Claims data on daily basis.
• Designing claims reconciliation, validation and analysis reports for accounting and actuarial departments.
• Designing complex ETL processes to support feeds from different sources like flat files, excel, csv, oldeb etc. using SSIS.
• Developing complex SSIS packages using different data transfermations like Aggregatation, Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Chagning Dimmensions, Scripting with C#, OLEDB Command with SQL etc.
• Devloping SSIS packages that uploads multiple flat files using Foreach Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.
• Designing internal and external surveys using .net technology and providing automated report for analysis of the survey results built in SSRS. Reports provides the functionalities like drill down, dash borad, drill thourgh, grouping, aggregation etc.
• Managing small DBA realted tasks like database backups, restores, log shipping, setting up databse access etc.
• Managing and supporting Mobile App realted customer inquires and providing solution to custmore service reps or directly to customers.
• Managing and enhancing internal and external website for the company with Umbracco and .net techonology.
• Working with Marketing department to improve external and internal website and posting latest updates.
• Designed new contract log management system for the legal and accounting department to help track of all the existing and new contracts. Also system manages preapproval process with defferent stages of approvals.
• Managing compnay’s video conference system and arraning video and gotomeeting setups for HR department.
• Helping finance and accounting department with crystal report’s enhancement and resolving issue with reports.
• Working with other departments to support different needs and help them resolve day to day issues with software and reports.
• Working on Sales force to help users with account setup, designing email templates, sales force reports, Eblasts etc.

Environment: SQL Server 2012, SSRS 2012, SSIS 2012,.Net Framework 4.5, C#.Net, XML, Entity Framework, Umbraco, Sales force

Confidential

Consultant

Responsibilities:

• Work with clients to analyze and understand the requirements.
• Creating tables, views, stored procedures, triggers, user defined functions in SQL Server 2008.
• Enhancing and turning existing stored procedures to improve system performance.
• Building SSRS reports and integrating them with front end using C# script.
• Designing ETL process to load the feeds from other databases and file systems using SSIS.
• Working on middle layer using new .net technology like entity framework, LINQ etc
• Providing user support by solving and helping them with queires releated to the system.

Environment: SQL Server 2008, SSRS 2008, SSIS,.Net Framework 4.0, C#.Net, XML, ASP.Net, Java Script, Entity Framework, LINQ

Confidential, New York, NY

Analyst

Responsibilities:

• Work closely with Business analyst to analyze and understand the requirements.
• Creating flowcharts, data flow diagrams and support documents with detailed description of each new module.
• Creating star schema data models, performing ETLs and validating results with business analyst.
• Designig Business Objects Universe and creating Webi Reports.
• Managing BO Administration activity like server management, creating user profile and access rights etc.
• Building SSIS packages for loading data from different sources like excel files, flat files, SQL server etc.
• Desigining analysis reports using SQL server reporting services.
• Creating Autosys jobs and scheduling process for ETL.
• Maintaining and enhancing Informatica ETL workflows.
• Writing and tuning complex SQL, stored procedures and triggers in SQL Server.
• Created new applications using .Net BO APIs, Mult-Threading, Processes, events and windows services like Server Monitor tool and automated server rebooting process.
• Maintaining and enhancing existing .Net applications by adding new features to help monitoring data loads.
• Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.

Environment: SQL Server 2005/2008, SSIS, Informatica, SSRS, Business Objects Universe Design, Webi Reporting, CMS Management, C#.Net, ADO.Net, XML, ASP.Net, Business Objects .Net SDK, Self Service Packaging