SUMMARY

• 6+ Years of IT experience in Designing, Development, Implementation & Maintenance of Database development & Administration.
• Experience in all phases ofSoftware Development Life Cycleinvolving System Analysis, Design, Development and Implementation.
• Hands on experience in Installation and configuration ofSQL Server 2008R 2/2012/2014/2016 technology, Service packs and hot fixes.
• Extensively worked and had good knowledge on Integration and Reporting Services and good experience in data migration from Oracle/Access/Excel Sheets to SQL Server.
• Worked on administration tasks such as Data loading, batch jobs, data unloading, backup and recovery, user and application table management, upgrades, creating databases.
• Expert in createtriggers, stored procedures, user functions, views, indexes, user profiles, data dictionaries, CTEs and data integrity usingT - SQL.
• Expertise inData Modelingtool Power Designer.
• Involved inERdiagrams (Physical and Logical using Power Designer) and mapping the data into database objects. Developed Report Models using report builder and distributed reports in multiple formats usingSQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Experience in Monitoring Performance using various SQL Server inbuilt tools like Performance Monitor, SQL Profiler, Event Viewer, Execution plans, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries etc.
• Hands on experience in creating end to end ETL strategies dat will include data profiling as well as extracting transforming, conforming and loading data warehouses/ data marts for reporting purpose.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Good knowledge on Confidential Azure.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and securing packages secured packages with Encryption in conjunction with passwords.
• Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS.
• Data Migration to MS SQL Server using SSIS in BIDS and DTS.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 2008R 2/2012/2014/2016 , MS Access 2007/2010/2016

BI Tools: BIDS/SSDT, SSIS, SSAS, SSRS, Power Pivot, Power View

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, SQL Profiler, DTS, Upgrade Wizard, Jobs and task creating and scheduling, MS Visio

Programming Languages: SQL, T-SQL, XML, PL/SQL, C, C++, C#.Net

Operating Systems: Windows 7/10, Windows Server 2008/2012/XP/NT 4.0

Other Technologies: TFS, Code Collaborator, Quality Center, MS Office, MS Project, Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SQL/ETL Developer

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Designed SSAS cube to hold summary data for dashboards. Developed Cube with Star Schema.
• Involved in Type 1 and Type 2 slowly changing dimensions using SSIS and Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS.
• Created different type of reports including: A Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Responsible for creating SQL datasets for Power BI.
• Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data sources.
• Used Temporary tables, Table variables and Common Table Expressions (CTE) depending on the requirement. Transferred data from various sources like MS Excel, Flat File and SQL Server using SSIS and then created reports using this data using SSRS.
• Developed critical SSRS reports using T-SQL stored procedures with parameters and without parameters and complex SQL queries with custom coding for dynamic tables.

Environment: MS SQL Server 2016/2014/2012 , SQL Server Integration Services, SQL Server Reporting Services, BIDS, T-SQL, MS Excel, Windows 2008 Server, Power BI.

Confidential, Philadelphia, PA

SQL BI Developer

Responsibilities:

• Worked with business users and business analyst for requirements gathering.
• Extracted Data from various sources like flat files, MS Excel, MS Access Oracle and Sqldata based on user requirement using with SSIS and loaded data into target, by scheduling the sessions.
• Written SQL Scripts and Views to extract data from database and for Application Reporting Purposes.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Using with SQL scripts generated Mothly Applications reports for Business Users.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Designed and created Web base Report system using SSIS,Excel Pivot tables.Used complex stored procedures and parameterized queries to provide secure, accurate and efficient data in easy to read, user friendly format.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Provided documentation for the implemented procedures which involves Go Live activities and support work.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.
• Proficient in Migration of Data from various heterogeneous sources to MS SQL server by using SSIS/DTS utility or by Linked Server.
• Monitored and troubleshoot jobs in production, preview and development servers.
• Worked on Query Optimization, analyzing the execution plan and index management for better Query performance
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Ensure regular Database backups and implementing tests on backups and generating reports.
• Worked on database activities not limited to resolving performance issues, utilizing high availability options, create/drop/offline database, solving job failures, start stop SQL services.
• Performed maintenance activities like analyzing/rebuilding indexes, update statistics based on business needs.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Environment: SQL Server 2008R2/2012/2014 SQL Server Agent, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Access, SQL Agent, Erwin, TFS, SharePoint, Power Pivot, Windows Server.

Confidential, RI

MS SQL BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db).
• Extracted and Transformed data into Staging Servers named as PStaging Server for historical data and TStaging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package dat executes.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Developed and conducted unit testing the Informatica mappings/worklets/workflows and scheduled them. Preparation of system test plan.
• Tuned SQL query for better performance using SQL Profiler.
• Documented all work, so user can easily understand the flow of process.

Environment: MS SQL Server 2008R2, SQL server Reporting Services(SSRS)-2008R2/2008, SQL Server Integration Services (SSIS)-2008R2/2008, Informatica Power Center 9.5.1, Confidential Visual Studio, T-SQL, ERWIN, Database Engine Tuning Advisor, SQL Server Profiler, MS Excel

Confidential

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Designing and developing SQL Server 2005 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2005
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, cross tabreports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Developed the packages in order to extract data from SQL db, flatfiles and loaded into Oracle database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS
• Performed data conversions from flat files into a normalized database structure.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting
• Installed and configured the components required to integrate SSRS with MOSS Enterprise Edition
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server
• Data migration (import & export - BCP) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in designing, programming, deployment and Unit Testing of requested Reports

Environment: MS SQL Server 2008, MS SQL Server Management Studio, SSIS-2005/2000, SSRS-2005/2000, .Net framework, C#, Confidential Excel 2007, Windows 2000, Confidential project.