SUMMARY

• Over 6 years of IT experience as MS SQL Server Developer 2012/2008 R 2/2008/2005/2000 in various Industry verticals like Insurance, Airlines, Telecommunication, Pharmaceutical, Retail and Bank.
• Extensive experience with different phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Extensiveexperiencein writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document with detailed description of logical entities and physical tables.
• Experience in Installation and Configuration of SQL Server 2008/2005/2000.
• Excellent knowledge in Creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, SQL Joins, Query Writing, Data Dictionaries, Data Integrity, Cursors and Indexes using T-SQL.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Highly experienced in complete cycle of SQL Server Integration Services (2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS) (2005/2008).
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access and designed data conversions from wide variety of source system.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005 .Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
• Expert in creating packages, Jobs, Sending Alerts using SQL Mail. Experience in SQL Server Analysis Services (SSAS) OLAP Cubes and Data Mining, SSAS 6.5/ 7.0/ 2000/ 2005/ 2008/2008 R2/2012.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0,Perl,CSS, HTML, XML, MHTML

Databases: SQL Server 2012/2008 R 2/2008/2005/2000/7.0 , Oracle 9i/8.x, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), SSAS(SQL Server Analysis Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2007/2003/2000 , Adobe Professional, SharePoint

Operating Systems: Windows 8/7/2003/2000/ XP, Unix.

Database Tools: SQL Query Analyzer, SWIFT Tool, ERWIN, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

SQL BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created data loads and Performed Data validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.

Environment: SQL Server 2012/2008R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Analyzed existing logicaldatamodel (LDM) and made appropriate changes to make it compatible with business requirements.
• Worked on identifying facts, dimensions and various other concepts of dimensionalmodeling, which are used for datawarehousing projects.
• Optimized cubes for better query performance.
• Aggregated cube with 30% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Used Database engine tuning advisor, SQL Profiler for Performance Tuning.

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows 2003/2000 and T-SQL.

Confidential, Pittsburgh, PA

SQL BI Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
• Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Configured file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Environment: SSIS, MS SQL Server 2008, Windows 2003

Confidential

SQL BI Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Created data loads and Upgrade scripts for data migrations and validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.

Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Confidential

SQL Server Developer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
• Created different user level groups, and assigned appropriate permission level to the database.
• Preparation of project documentation.

Environment: SQL Server 2000/2005, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server