SUMMARY:

• Around 7 years of IT experience in Database Design, Application Development, Testing, Implementation, Deployments and support of ETL processes for large - scale Data Warehouses using SQL Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Analysis Services(SSAS) and SQL Server Reporting Services (SSRS).
• Experience in DB Design & implementing SQL Server 2005/2008 Stored Procedures, Triggers, Indexes, Views, Functions
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Very strong SQL skill in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers in­­ SQL Server 2008.
• Experience in ETL (Extraction, Transformation and Loading) using SQL Server Integrated Services (SSIS) from various Data sources to different Databases.
• Extensive experience in designing, developing and deploying Business Intelligence (BI) solutions using SSIS, SSRS and SSAS.
• Proficient in creating highly analytical & detailed reports from ERP system for various departments like sales, purchasing, inventory, financial, customer service, marketing, data warehouse, and human resource by using SQL Server Reporting Service, SQL Server Analysis Service (OLAP).
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS) using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
• Worked on Performance Tuning SQL’s, Query Optimization, identifying and resolving performance bottlenecks in various levels like sources, targets and mappings.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. SQL BI Developer

Responsibilities:

• Review the Business requirements and develop technical and functional specifications within time and cost constraints.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Responsible for creating the reports based on the requirements using SSRS 20012/2008.
• Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create parameterized and cascading parameterized reports.
• Designed various managed reports as per the requirement, like sub reports, parameterized report, drill down, drill through using data warehouse and analysis services or cube as source.
• Developed Ad-hoc report using report model, with ability to create multiple reports by non-technical managers by just using drag and drop functionality in report builder.
• Proven ability in defining Query for generating drill down reports in SSRS 2012/2008.
• Developed Sales report, Financial report, Policy report and Premium reports for the company.
• Worked with the HP Application Lifecycle Management (HP ALM) for issues with existing reports and task allocation.
• Worked on de-bugging package execution using break points in control flow and data viewer in data flow.
• Monitored packages using audit, loggings and custom loggings of several events.
• Mostly used XML package configuration in packages making easy to move into production environment.
• Main scope of the project was conversion of Business Objects Reports (Profit and Loss Reports, Balance Sheet Reports and Analytical Reports) to Webfocus Reports.
• Coordinated successfully with business users, business analysts and data analysts regarding the overall requirement and requirements for each specific report development and delivery methods.
• Worked on the AGILE Scrum Methodology for this project during which each sprint lasted for about 2 weeks.
• Worked on SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reports.

Environment: MS SQL Server 2012/2008, SSAS, SSIS, SSRS, Windows 2003 Server, ER-win, T-SQL, SQL Profiler/Data Tuning Advisor (DTA), SQL Server Management Studio.

SSIS/SSRS Developer

Responsibilities:

• Hand-on working experience in creating SQL Server Reports using SSRS
• Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
• Involved in gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design documents and Approach documents.
• Worked with BA/BSA, Data Modeler/Architect team in designing the Data Model for the project.
• De-bugged SQL script used in company’s intranet applications, and re-designed or modified as required.
• Created several SSIS master child packages for loading data from various heterogeneous sources, cleaning data and populating the data marts.
• Implemented slowly changing dimensions (SCD) Type 1 and Type 2.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Dimension and Fact tables using SSIS.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Successfully worked in all the phases of report development Authoring, Designing and Rendering
• Actively involved in interacting with end user gathering business requirement and ensuring the report design.
• Used the SSIS Configuration files to make the packages connections, variables etc configurable and maintained the same on Test and Production environments.
• Improved performance of the system by suggesting composite indexes and tuning of the existing Database Objects.
• Helped the users to test the reports created and optimized the performance of the end reports getting the data from SQL server Databases.
• Data conversions and data loads from various databases and file structures.

Environment: MS SSIS 2008, Visual Studio 2005, Windows 2012 Server, MS Office 2012, MS Access, Toad, MS Excel 2012.

SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed, implemented and administrated SQL Server 2008 databases.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Prepared Technical Required Documents along with Design and Mapping documents.
• Designing, Developing and Testing software applications and systems according to project requirements using various tools and technologies such as MS SSIS, Oracle, DB2, SQL server, UNIX, SQL and PL/SQL.
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc.
• Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services (SSIS).
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Developed & implemented Financial Analysis Reports using SSRS/Tableau.
• Using SQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data.
• Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in MSSQL Reporting Services (SSRS).
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS packages.
• Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored procedures and SQL objects and also Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Implemented Custom Error Handling (Record Level) by using the Script component to generate custom error messages and redirected the error rows to a staging error table.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Worked on de-bugging package execution using break points in control flow and data viewer in data flow.
• Used Deployment Utility to effectively deploy the ETL Packages from Development to Production Environment
• Worked on modifying existing the reports for changes according to the requirement.
• Worked closely with Business team and end users to translate reporting requirements into feasible end products
• Used Developer Studio and Application Studio extensively in creating the reports.
• Experience in SSIS package (Microsoft SQL server 2012) using import/export wizard.
• Generated parameterized, drilldown, drill through, linked reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Environment: MS SQL Server 2008, SSIS, Windows 2005 Server, SQL Server Management Studio, SQL Server Business Intelligence Studio, Query Analyzer, ER-win, MS Access 2005, MS Office and Excel 2008, SQL Profiler, UNIX, Shell Scripting.

SQL Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster Index, Unique/Check Constraints, Default, Views, Stored Procedures, Joins, and Functions.
• Experience in Teradata databases, by creating SSIS packages and Teradata act as source and SQL Server act as a Destination
• Enabled Error handing in Data Flow Task Level. Maintained logs and configured Send Mail Task to send e-mails if package fails.
• Extensively performed Bulk Data Migration in Incremental way by using both Staging and Target Databases
• Created Test Data, Production Data and Training Data using SSIS Packages.
• Extensively used XML and dataset for accessing data from SQL Server 2008 database.
• Responsible for production support and release and resolved the production issues
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements

Environment: SQL Server 2008/2008rR2, DTS, C#, .Net, T- SQL , Windows 95/NT/2000/2003, Teradata, XML, MS Excel, MS Access, MS visual Studio, BIDS.

Junior SQL Developer

Responsibilities:

• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Actively involved in interacting with end user gathering business requirement and ensuring the ETL design
• Created Jobs using SQL server agent to automatically run the packages, stored procedures in scheduled time.
• Created DTS packages to transform data from various data sources using OLEDB connection.
• Performed administration tasks like managing users, login Ids, roles and profiles.
• Wrote optimized SQL queries in SQL Query Analyzer for efficient handling at huge loads of data.
• Scheduled and monitored various ETL jobs like package execution using the SQL Server Agent.
• Wrote DDL, DML statements, complex stored procedures, triggers and User defined functions for the purpose of database development.

Environment: SQL Server 2008/2008R2, SQL Server Management Services (SSMS), DTS, C#, UNIX, Shell Scripting.