SUMMARY

• 9 + years of strong IT experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008/2005 with various business domains like Banking, Insurance and Health care.
• Sound knowledge of software development life cycle ( SDLC ) with substantial experience with object oriented analysis and design methodologies.
• Exceptional hands on working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Extensive Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance, Enhancements of Data warehouse, and ODS systems using Informatica 9.x/8.x, Oracle 11g/10g, DB2, SQL Server, Teradata, PL/SQL, and well versed with Data Warehousing Architecture Technology, Operational Data Store, and Dimensional Data Modeling.
• Expertise in Data Warehouse Modeling with SQL Server Analysis Services (SSAS ).
• Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.
• Very good knowledge in scheduling and deploying reports on report manger.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in TOAD v9.5 for developing and managing PL/SQL scripts.
• Good Hand on Resolving complex issues and Error Handling in SSIS .
• Created cluster index and non - cluster index on tables and disable them before inserts and enable when inserts completed.
• Expertise in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Very good knowledge of MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Expert in T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Developed and implemented the application code in Oracle PL/SQL and T-SQL.
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Data Modeling: Data Modeling experience using Dimensional Data modeling, Star Schema, Snow- Flake Schema, FACT and Dimension tables, Physical and logical data modeling, and Erwin 4.1.4.

Databases: Oracle 9i/10g/11g, MS-Access, DB2, MS SQL Server, Teradata, MySQL, and Sybase.

Programming: SQL, T-SQL, PL/SQL, Unix Shell Scripting, and exposure to SAS, JAVA, and PERL.

Domain Knowledge: Banking, Insurance, Healthcare, Spend Data Analysis, Sales and Warranty Analysis, Manufacturing, and Education.

Environment: Windows 98/NT/XP, Windows 7 Professional, UNIX (AIX), and Linux.

Miscellaneous: MS Office, Visio, Hyperion, Toad, Control M, and exposure to Cognos, Business Objects, UC4, OBIEE, ODI, Brio, and Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

MSBI Developer

Responsibilities:

• Enterprise Reporting Management of Microsoft was used to generate the reports for finance and operations which was built on the top of multidimensional cube and migrated into tabular modal.
• Did different POCs like Process Control Framework POC - To verify multiple worker thread under one PCS master job.
• Tabular With 500 Million Rows - To test performance and scalability of tabular.
• PNL Report - To avoid customization like in existing PNL report using tabular cube.
• Troubleshooting of the burning issues in tabular and multidimensional cubes.
• Translated the existing Reports from Translational to Dimensional in SQL Server Management Studio.
• Created complex Stored Procedures , User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Wrote complex stored procedures to process requirement and generating records between front End and back end.
• 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, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Created New Reports by using SSRS & did the performance of SSRS Reports.
• Established the relationships among the tables in the database by assigning primary keys, Foreign keys and established the referential integrity.
• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Extensively involved in the design of SSAS & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube using SSAS
• Created Tabular Models using DAX queries in analysis services and deployed it.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created POWER BI Visualizations and Dashboards as per the requirements.
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.

Environment: T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), Visual Studio 2016, OLAP.

Confidential, NC

Sr. SSIS/SSAS 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, and SQL).
• Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging 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 that executes.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• 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 packages.
• 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, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
• 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 the required Metrics and KPI's using DAX formulas.
• Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

Environment: SQL Server 2008/2005, Windows Server, SSIS, SSRS and TFS, ProClarity/PPS, EDW, ODS, EDS

Confidential

Sr. SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in the Installation and Configuration of SQL SERVER 2008 with latest service packs.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• 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 packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• 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.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes using the TF Dimension Merge Slowly Changing Dimension (Task Factory Tool).
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output by TF Error Output Description (Task Factory Tool).
• Identifying the mapping issues and discussing them with business analysts in team.
• Handled the database components (Code migration, Change control) for application releases.
• Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.

Environment: SQL Server 2008/2005, Windows Server 2003, SSIS, SSAS, SSRS and TFS, ProClarity/PPS, EDW, ODS