SUMMARY

• Around 7 years of IT industry experience with Microsoft SQL Server 2000/2005/2008 , SSIS/SSRS as SQL Developer.
• Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• Expertise in scripting T - SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Extensive experience in Performance Monitoring and Tuning of SQL Statements, Sub Queries, Joins and Functions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Expert in working with Business Intelligence Development Studio (BIDS), that includes SSIS, SSRS.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Expertise in developing reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Sub reports and formatting them using both SSRS 2005/2008.
• Extensive use of Agile Methodologies, including Extreme Programming, Test-Driven Development and Scrum.
• Expert in creating high level dashboards using SQL Server Reporting Services.
• Excellent command on Insurance/Financial (BNFS) Domain along with deep Conceptual and Practical Knowledge.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

BI Tools: SQL Server Business Intelligence Development - SSIS SSAS, SSRS, DTS.

RDBMS/DBMS: MS SQL SERVER 2000/05/08, MS Access.

Servers: Active Directory Server, IIS

Web Technologies: C#, ASP.NET, ADO.NET, HTML

Version Control Tools: Visual Source Safe, SVN

Client Server: Web Services

Scripting Languages: JavaScript, Jquery

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Project Lead

Responsibilities:

• Design and develop solutions to fix identified problems.
• Implement best programming practices in software engineering.
• Study and recommend corrective solutions for enhancing manufacturing efficiency.
• Participates in activities such as analysis, design, reviews, problem solving, gap analysis and root cause analysis and configuration resolutions.
• Participates in creation of deliverables, WBS, BRD and quality review as needed.
• Identify root causes of technical issues in production and out of box failures.
• Manage the team, Project planning, Project tracking and status reporting to the Client.
• Involved in production support and all the related activities.
• Documentation of various processes and issues for future reference.
• Develop detailed specification or the provided business.
• Code construction and unit testing.
• Perform internal code walkthrough and facilitate code walkthrough with Client personal.
• Provide resolutions to issues identified with application in scope during execution of integration test/system.
• Test/regression test by QC team for enhancements as and when required.

Environment: Microsoft visual studio.NET 2010 & SQL Server 2008

Confidential - Phoenix, AZ

Project Lead

Responsibilities:

• Understanding the requirements and prepared Requirement document, design document, Project Charter.
• Created Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Tuned database by creating proper indexes.
• Created data dictionary for all columns and documented all the processes involved in maintaining the database for future reference.
• Code Review, Unit Testing and Defect fixing.

Environment: Microsoft visual studio.NET 2010 & SQL Server 2008

Confidential - Phoenix, AZ

SQL Developer (SSIS, SSRS)

Responsibilities:

• Responsible for developing new modules as per client requirement.
• Understanding the requirements, analyze and make Use Case & design document.
• Created Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Used Joins for complex business queries involving multiple tables from different databases and implemented stored procedures and enforced business rules via checks and constraints.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Expert in Creating and Deploying SSRS reports on the portal for user accessibility.
• Used cascaded parameters to generate a report from two different Data Sets.
• Generated Configuration files, logging and created breakpoints for SSIS packages and deployed to development, QA and Production Environments.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Extensive use of Agile Methodologies, including test-Driven Development and Scrum.

Environment: SQL Server 2005, SSIS, SSRS, Business Intelligence Development Studio (BIDS), Microsoft visual studio.NET 2008.

Confidential

Sr. SQL Developer

Responsibilities:

• Coding & manual testing.
• Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Developed, deployed and monitored SSIS Packages.
• Used SSIS packages to move logins and jobs from one server to another server.
• Implemented error handling processes to the ETL packages.
• Involved in Preparation/Author of ETL tools and packages to extract heterogeneous data from Excel, Flat file, XML, OLE DB Source to SQL Server 2008 R2.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Building UAT and Test environments using Production backups.
• Created Stored Procedures, Triggers, Views and User Defined Functions to support the Application.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Optimized existing stored procedure code system processing and indexes.
• Created test plans in Quality Center and written test cases for unit level, functional and integration testing.

Environment: SQL Server 2005, SSIS, SSRS, Business Intelligence Development Studio (BIDS), Microsoft visual studio.NET 2008

Confidential

Software Engineer

Responsibilities:

• Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Coding & manual testing
• Involved in creating, deploying and configuring reports according the requirements.
• Involved in writing scripts for the clients requirements for generating reports.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Involved in creating, deploying and configuring reports according the requirements.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Fixed reports and bugs in stored procedures.
• As a DBA involved in maintaining the Database Backups for the team using SQL lite speed backups, database performance tuning, using migration methodologies for improvement.
• Documented the flow of the project.

Environment: SQL Server 2005, SSIS, SSRS, Business Intelligence Development Studio (BIDS), Microsoft visual studio.NET 2008.