SUMMARY

• SQL Server/BI developer with more than 9+ years of IT experience in Database/ Data Warehouse design, development & administration using Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS)
• Experience in full IT development Life Cycle in Financial and Healthcare industry
• Expertise in creating/modifying Tables, Views, Stored Procedures, Functions, indexes and Triggers and in depth knowledge in query optimization & performance tuning
• Have strong experiences in creating SQL Server SSIS packages (ETL) to import, extract, and transform data between databases and external data sources
• Highly Experience in T-SQL (DDL, DML), documentation, coding, programming and using SQL Server 2000/2005/2008.
• Used Version control tool Team foundation server (TFS) for the entire development cycle.
• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Hands on experience in using version control software s like VSS, Rational clear case and (TFS) Team Foundation Server.
• Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations
• Experience in migration of data from external database such as MS Excel, MS Access, Oracle, and DB2 into MS SQL Server by using Import Export Wizard, DTS and SSIS / ETL
• Proficient in exporting and importing data to and from SQL Server to any OLEDB and ODBC provider using extensive knowledge
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experience in developing reports using MS SQL Server Reporting Services (SSRS) 2012/2008R2/2008/2005
• Experience in creating ad-hoc reports by using Excel and Report Builder in SSRS 2012/2008R2/2008/2005
• Experience in creating and developing OLAP cube using SSAS
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports
• Experience in designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems
• Experience in developing physical database architecture using Erwin Data Modeler
• Excellent Analytical, Interpersonal and Communication skills, fast learner, diligent and versatile team player
• Experiences in various types of financial products: Mutual Funds, Index Funds, Credit Rating
• Ability to work independently or as part of a team to accomplish critical business objectives as well as good decision making skill under high pressure or complex scenarios.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• Transact-SQL (T-SQL)
• Visual Studio
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• SQL Server Profiler
• Version Control
• Visual SourceSafe (VSS)
• Team Foundation Server (TFS)
• SQL Query Analyzer
• ERWIN
• Netezza
• MS SharePoint
• MS Access
• MS Office Suite
• MS Dynamics CRM

PROFESSIONAL EXPERIENCE

Confidential - Deerfield, IL

Sr. MS SQL Developer/ BI Developer (SSIS/ SSRS)

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers.
• Built custom framework of SSIS packages for better audits and used event handler for error handling of Packages.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Involved in creation/review offunctional requirementspecifications and supporting documents for business systems, experience in database design process and data modeling process.
• Used Team Foundation Server (TFS) for central repository as a versioning control.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• The packages created included a variety of transformations, for exampleSlowly Changing Dimensions,Script task, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversion.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Responsible for creating datasets using T-SQL and stored procedures.
• Involved inTabular Data warehousefor SSAS 2012 and 2008 OLAP databases.
• Generated reports using SQL server reporting services.
• Used SSRS for creating matrix and tabular, drill down, drill through, and parameterized reports based on requirements.

Environment: MS SQL Server 2012, T-SQL, Microsoft Visual Studio, SQL server Integration Services, SQL server Reporting Services, SQL Server Profiler, Microsoft Visual Studio, Microsoft Visual Basic, team foundation server(TFS), VSS, Tableau, MS Visio, SQL Server Agent, Windows 7, SQL Server Management Studio, MS Office 2010.

Confidential - Chicago, IL

SQL Server Developer/ MS BI Developer (SSIS/ SSAS/ SSRS)

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, extraction and transformation.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan,SQLProfiler and Index Wizard to optimize queries, locate and eliminated bottleneck and enhance the performance of databases.
• Used bulk insert in SSIS and SSMS for faster transfer of data.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
• Created Multi-Dimensional cubes using SSAS 2012 based on business requirements.
• Used MDX to extract cube data and created pivot tables for revenue analysis.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Used sub reports functionality for complex report calculations.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2008R2, Microsoft Visual Studio, SQL server Integration Services, SQL server Reporting Services, SQL server Analysis Services, SQL Server Profiler, Netezza, Cognos, Erwin r7.2, MS Dynamics CRM, Windows 7, MS Office 2007/2010, Visual SourceSafe (VSS), MS SharePoint.

Confidential - Itasca, IL

MS-SQL Server / MS BI Developer (SSIS/ SSRS)

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Experienced in creating package dynamics by using SSIS expressions and variables.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created reports using SSRS based on business requirements.
• Developed drill down, drill through, and parameterized reports using SSRS.

Environment: MS SQL Server 2008, Visual Studio 2008, SQL server Integration Services, SQL server Reporting Services, SQL server Analysis Services, TFS, VSS, MS Visio, MS Office 2007(MS Excel, MS Access), MS Windows Vista.

Confidential - Lexington, KY

MS SQL Server/ MS BI Developer (ETL/ SSAS/ SSRS)

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Performed ETL using SSIS by extracting data from OLTP data sources such as Excel, Access, and Text files.
• Transformed data sources and loaded to SQL server.
• Identified data source and data views for building the OLAP cube in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Created Parameterized, matrix and drill down reports using SSRS 2005.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2005.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Deployed the generated reports created using SSRS 2005 on to the server.

Environment: MS SQL Server 2008, T- SQL, MS SQL Integration services, MS SQL Server Reporting Services, Erwin, MS Office(MS Excel, MS Word, MS Access), Visual Studio 2008, MS Windows XP

Confidential - Dallas, TX

Sr. MS SQL Developer/ BI Developer (SSIS/ SSRS)

Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Formatted the reports using the Global variables and expressions.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005, MS SQL Reporting Services 2005, Microsoft Visual Studio SSRS.