PROFESSIONAL SUMMARY:

• Eight (8) years of experience in design, development, analysis and administration of SQL Server 2005/2008R2/2012/2014 and SQL Server Business Intelligence tools (SSIS, SSAS and SSRS).
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) and SQL Server data tools (SSDT).
• Good Business and System analysis skills to understand teh requirements and customize client applications.
• Working experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, and DCL commands for various business applications.
• Highly proficient in teh use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Solid knowledge and recent experience wif all aspects of SQL Server Management Studio (SSMS) including Query Editor, SQL Server Agent, Management and Notification Services.
• Worked extensively on creating complex queries including correlated queries and queries wif complex joins involving multiple tables and aggregate functions.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data.
• Created views to display required information on user interface, and triggers to validate consistent data entry into teh database.
• Expertise wif job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Experience in Designing and Building teh Dimensions and cubes wif star and Snowflake schemas using SQL Server Analysis Services (SSAS).

TECHNICAL SKILLS:

• MS SQL Server 2014/2012/2008R2/2005
• MS SSRS 2014/2012/2008/2005
• MS SSIS 2014/2012/2008/2005
• MS SQL SSAS 2014/2008/2005
• T-SQL
• C#
• MS Office
• Windows 2010/2007/ 2000/ XP server
• Note++
• JIRA
• Task Force
• TFS
• Power Bi
• Power Pivot
• Tableau Desktop
• Tableau Server.

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

MSBI/SSRS Developer

Responsibilities:

• Generated, Monitored and Maintained teh financial dashboard for Confidential Puerto Rico halth plan by utilizing SSIS, SSAS, PowerPivot tools. It helps to teh health plan to identify teh gain and loses on monthly basis.
• Generated “Performance Report” for teh Confidential Puerto Rico region’s call center by utilizing PowerPivot, SSRS and SSAS tools. Created Tabular cube to include live data in teh report as per teh user’s request.
• Developed Medicare Alert report for Confidential Wisconsin health plan. It helps to teh business to identify teh dual eligible members for teh health plan.
• As a part of teh Confidential reporting team I has generated reports by utilizing PowerPivot, SSRS and Power BI tools.
• Performed as a team player to develop Confidential ’s Executive dashboard on Tableau platform.
• Interacted wif business user and end users to gatheird requirements for teh Ad-Hoc reports. It fastens teh process of reports development.
• Co-ordination wif Business and On-site development team and to mentor teh offshore development team.
• Migrated 2008 SSIS packages to 2014 to improve teh performance and maintain teh business needs.
• Interface wif internal business users as well as various IT development groups so teh needs can be clearly understood, expectations managed and change initiated.

Confidential, Baltimore, MD

MSBI Developer (SSIS/SSRS/T-SQL)

Responsibilities:

• Designing and developingparameterized reports, Drill down report, drill throw report, linked reports,sortingreports, matrix and tabular reportswif drill down option usingSSRS.
• Created Views, store procedures to facilitate easy user interface implementation.
• Co-ordinate wif business and created documents for existing store procedures to help new reporting team.
• Used different source to pull data for SSIS packages and pushed to Salesforce after transform data.
• Developed Resource Management Dashboard for National Border Guard using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart on Tableau platform.
• Utilized Tableau server to publish and share teh reports wif teh business users.
• Aligned SQL Mail agent for sending automated alerts/email of SSRS reports.

Environment: MS SQL Server 2014/2008R2, SSIS, SSRS, Windows Server 2007/2010, JIRA, TFS, Sales Force, Task Force, Note++, MS Excel, MS Office.

Confidential, San Antonio, TX

MSBI Developer (SSIS/ SSRS / T-SQL)

Responsibilities:

• Involved in designing teh data warehouse and core Database for teh system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Involved in performance tuning of teh database and T-SQL queries using Explain Plan.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Developed C# scripting for SSIS packages using script task
• Performed activities like analyzing and improving teh architecture of databases, creation & indexing of teh tables.
• Create SSIS packageswif control flow tasks, data flow task and event-handling techniques, create datasets inT-SQL.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2005, and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Configured SQL Mail agent for sending automated alerts/email.
• Gather requirements from users Confidential chat sessions and interviews.
• Adept Confidential preparing business requirements documents, defining project plans, writing system requirement specifications.
• Provided documentation for all kinds of SSIS packages.

Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, Windows Server 2007, TFS, Note++, MS Excel, MS Office, C#.

Confidential, Hillsboro, OR

MSBI Developer (SSIS/SSRS)

Responsibilities:

• Creating and managing draft objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created different types of User-defined functions and Stored procedures using T-SQL.
• Wrote database triggers in T-SQL to check teh referential integrity of teh database.
• Used Shared Connection managers, implemented error handling in SQL Server 2012.
• ETL, data profiling, data quality and clean ups for SSIS packages.
• Designed Logical and Physical Data Model wif Erwin tools.
• Created SSIS Packages to populate data from various data sources.
• Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked wif Meta-Data Driven SSIS Packages to pull teh data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012.
• Downloaded reports from teh Crystal environment wif teh Download utility tool and migrated reports using teh Data source migration wizard and published teh reports using teh Publishing wizard.
• Developed SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Work wif project teams for upgrading SQL Server 2008 to SQL Server 2012.

Environment:Microsoft SQL Server 2012/2008 R2, Microsoft Visual Studio 2012, Windows Server 2003, T-SQL, MS Word, MS Excel,MS Visio, C#, .NET.

Confidential, Middletown, NJ

MSBI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Created SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel and Access to SQL Server.
• Developed C# scripting for packages using Scrip task
• Involved in upgrading packages from SQL server 2005 to SQL server 2008
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve teh quality of software.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures dat accepts parameters.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Involved in creating OLAP cubes and dimensions for teh analysis using SSAS.
• Created a cube using multiple dimensions and modified teh Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Used SQL Server profiler for auditing and analyzing teh events, which occurred during a particular time horizon and stored in script.
• Involved in teh design and development of web forms for teh application using ASP.Net to take care teh cosmetic works of teh reports deployed on teh server.
• Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, SSAS, Visual Studio 2005, Erwin 7.2, Windows NT/2003, C#.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development.
• Developed complex Reformat mappings to reformat from Property Source (flat files) System to pre staging, from pre-staging to staging and staging area to Production DB.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run teh logic embedded in teh mappings.
• Developed Pl/SQL procedures & functions to support teh reports by retrieving teh data from teh data warehousing application.
• Created PL/SQL scripts to extract teh data from teh operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created different transformations like Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, Normalizer transformations for loading teh data into teh targets.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve teh performance as teh volume of teh data was heavy.
• Wrote shell scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control/auditing of different processes.
• Worked wif Memory cache for static and dynamic for teh better throughput of sessions containing Lookup, Joiner, Sorter and Aggregator transformations.
• Prepared documentation for business data flow from source to targets and also for teh changes made to teh mappings/sessions existing to eliminate teh errors.
• Responsible for migrating project between environments (Dev, Test, QA, Prod) and also between Operating systems using Static Deployment and Labelling.
• Coordinate wif onshore business team and offshore development team to implement teh project.
• Perform data validation tests using complex SQL statements

Environment: Windows 7, Informatica Power Center 9.0.1, Linux, DB2, Oracle, Tivoli scheduling.