SUMMARY

• Over 7 years of experience in designing, analyzing, adapting and developing data base solution and applications, and Business Intelligence solutions and applications using SQL Server 2012/2008R2 /2008/2005, SQL Server Integration, Analysis and Reporting Services(SSIS,SSAS,SSSRS) along with 1 year plus experience in analyzing, designing and developing web application and script using C# and .NET Framework 3.5/4.0/4.5/4.5.1
• Strong experience in Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS), Experienced in Migrating databases from SQL Server 2000 to SQL Server 2005.
• Experience in writing Complex Stored Procedures and Triggers, UDFs using control of flow statements in complex logic queries.
• Proficient in designing and deploying OLAP cubes for business analysis utilizing SQL server 2012/2008R2/2008/2005 and SQL Server BIDS and Data Tools.
• Experienced in ETL processes, Extensive experience in extracting, cleaning/transforming and loading data from Transactional Database and other data sources into Data Warehouses for future Business Intelligence Analysis using SSIS.
• Created dimensional model for teh reporting system by identifying required dimensions and facts usingErwin r7.1
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in teh form of Entity Relationships and elicit more information
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Proficient in designing and executing TSQL Query Statements implementing many types of Tables, Joins Constrains, stored procedures, Triggers and Exception Handling using SQL Server Management Studio.
• Experienced in creating script tasks and script components utilizing C# scripts in SSIS and SSRS
• Experience in developing Dashboard, Ad - hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled teh Reports in Report Manager.
• Extensive experience in understanding client’s requirements and translating them into enterprise solutions.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Excellent Communication and interpersonal skills, including analytical, problem-solving, leadership and computer skills.

TECHNICAL SKILLS

Operating System: Windows NT 4.0, Windows 2000 Enterprise/Advanced Server, Windows2003 Enterprise/Datacenter Server, XP Professional and Windows 2000, UNIX.

Databases: MS SQL Server 2008 R2/2005/2000, MS Access, My SQL

Programming Languages: T-SQL, C, C++, Shell Scripting, SQL, XML, C#, VB.NET, MDX

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS,SSAS,Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS) 2005/2008 R2.

ETL Tools: DTS, SSIS.

Data Modeling: Erwin v 4.0, Visio 5.0

PROFESSIONAL EXPERIENCE

Confidential, Menomonee Falls

SQL Server Developer

Responsibilities:

• Integrated teh data from different data sources using components like send mail task and scripts task written in C# with SSIS designer for excel file manipulation in order to validate teh data source.
• Created new packages, configured them using configuration manager, made changes object by object and property by property, saved it and then ran it.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on teh given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain teh required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from teh present columns for teh given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to Process teh cube, load data etc.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in teh data model as per new specifications in Erwin after analyzing teh database systems currently in use.
• Worked extensively on Erwin and ER Studio in several projects in bothOLAP and OLTP applications.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize teh report execution time and to limit teh no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on teh requirement. Linked reports are created in teh Report Server to reduce teh repetition teh reports.
• Designed models using Framework Manager and deployed packages to teh Report Net Servers.
• Created pages in teh reports to display depend on Prompt values.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Deployed and Published teh Created Reports to Microsoft CRM Application and Microsoft Share Point Server and also uploaded them to Microsoft Performance Point Server.
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Scheduled teh backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.

Environment: SQL Server 2000/2005/2008 , Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, ASP.NETC#.NET, SSRS 2005/2008, VBA, VB Script, IBM Informix, and UNIX.

Confidential, Dallas, TX

MS SQL Server Developer

Responsibilities:

• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Involved in design and analysis sessions with other BI teams to provide flawless design.
• Created and monitor SQL Server Agent Jobs to schedule weekly backup of logs to reduce database size and secure teh logging data.
• Streamlined database design process using creation of table structures in 3NF using DDL statements using T-SQL.
• Facilitated constraints such as Primary, foreign, default, unique and Not Null.
• Implemented Set-based DML statements such as set-based update and delete statements.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and fine-tuned existing stored procedures by re-writing sub queries as inner and left joins.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Created several database constructs such as views, triggers and extensively worked on performance tuning.
• Wrote complex nested Case structures to implement complex business logic.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
• Wrote complex stored procedures for streamlining incremental data loads using left join.
• Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to teh database.
• Designed ETL structures for data imports from various sources such as Oracle, Tera Data, Excel, Access and DB2.
• Implemented Data Warehouse ETL design structure utilizing Star Schema. Designed and developed Fact and Dimension structures for various types of data related health information of teh patients.
• Actively engaged in client meetings in requirement gathering and development updates.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Developed and implemented custom logging structure in Event Handlers for all teh SSIS packages using SSIS system variable such as Package Name, Package Start Time, etc.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Implemented SSIS and T-SQL executions as jobs under SQL Agent.
• Implemented system stored procedure sp send dbmail for notifications upon encountering job failures by sending notification emails for distribution lists.
• Actively utilized Microsoft Team Foundation Server and its features for code sharing and updates from other team members.
• Designed archive structure for error logs for auditing purposes using T-SQL and Integration Services.
• Proficient in writing distributed queries such as openrowset using Linked Servers in T-SQL.
• Extensively used T-SQL Pivot and Unpivot for de-normalizing and normalizing source data for designing daily data loads for Warehouse.
• Analyzed existing stored procedures using DB Tuning advisor for performance improvements.
• Extensively utilized expression and constraint feature for conditional processing of flat files and flow control in SSIS.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, SQL Profiler, Microsoft Excel and Access.

Confidential

Jr. SQL Developer

Responsibilities:

• Developed an ETL packages using SSIS 2005 in order to extract transactional data from teh store database and load it into a data warehouse for analysis purpose.
• Created Simple User defined Functions (UDF), Common Table Expressions (CTE), stored procedures and triggers dat were implemented in different steps of BI process.
• Developed ad deployed different reports such as drill down through, parameterized, ect. And implementing different visualization like bar chart, Pie charts, tabular presentation and others, using SSRS2005.
• Implemented credit card and PayPal payment options on teh company’s e-commerce website using Authorize.net and PayPal web services.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for teh tables.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer.
• Performed queries optimization suing SQL Profiler, Database Tuning Advisor and by creating different indexes on table such as Clustered, Non-Clustered and Full Text Indexes
• Created Database Maintenance Planner for teh Performance of SQL Server, which covers Database
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate

Environment: SQL Server 2005/2008, Teradata Query Analyzer, Excel (pivot tables) SSIS, SSRS, T-SQL, c#, Visual basic, Visual studio2005, Windows 2000/XP.

Confidential

Junior SQL Server Developer

Responsibilities:

• Created and maintained database objects.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic using T-SQL.
• Created various reports using MS Reporting Services.
• Assisted in writing and optimizing complex SQL Queries.
• Analyzed teh existing application programs and tuned SQL queries using SQL Profiler.
• Involved in writing scripts for teh programs.
• Loading data from various data sources using MS Data Transformation Services.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
• SQL performance tuning by modifying SQL or adding/changing indexes.
• Prepared teh reports for teh day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML etc

Environment: SQL Server 2000, Sybase, DTS, Excel, MS Access 2000, ASP, MS SQL Reporting Services.

Confidential

SQL server junior Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing teh database and all teh database objects.
• Designed and developed tables, view, stored procedures, functions, cursors and triggers in MS SQL Server database on Windows NT platform using TSQL.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Designed and developed a fully functional database by creating teh logical database design and implementing teh physical database design using MS Access and SQL Server 2000.
• Designed and developed forms using Visual Basic.
• Designed and developed reports using SQL Reporting Services.

Environment: Visual Basic 6.0, SQL Reporting Services, SQL Query Analyzer, SQL Server 2000, T-SQL, and Windows 2000, MS Access 2000, MS Excel 2000.