SUMMARY:

• I am a seasoned resource with extensive experience on BI development. I have experience working on enterprise level projects with clients like Confidential, Verizon, Confidential, etc. I have good experience creating complex queries, stored procedures, functions and triggers. I have broader experience with SSIS, SSRS, PowerPivot, PowerView, Power BI and Office 365. I have also basic experience with data modelling. I have experience monitoring junior developers in my current project.
• Summary
• Highly motivated Information Technology Professional with Over 8+ years of experience with a strong background in Data warehousing projects development and ETL & Reporting experience using SQL Server SSIS, SSRS, MS Power BI in various Industry verticals like Finance, Telecommunications and Health Care.
• Familiar with the entire phases of Software Development Life Cycle (SDLC) of SSIS Package Development from blueprinting to development, testing, implementation and post - implementation support.
• Financial Investment Experience in developing solutions for AUM (Assets Under Management), involved in defining Portfolio and Security Master, building Trading/Finance reports based on different products (Fixed Income, Equity, Structure, Alternatives).
• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2014/2012/2008 R2.
• Experience in Extraction, Transforming and Loading (ETL) using SSIS creating mappings/workflows to extract data from SQL Server, Oracle, Excel, CSV, DB, Access DB and Flat File sources and load into various Business Entities.
• Expertise in SSIS direct and Indirect Configuration (XML, SQL Server) set up, SSIS Audit, Logging, Error Handling, Expressions as well as Variables.
• Expertise in performance tuning of Data Flow Task in SSIS Packages.
• Experience in creating Historical and Incremental Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Create Views for Power BI Report and retrieve those views to construct Dashboard report in Power BI Desktop
• Power Bi installation in VM
• Integrated SQL server reporting services with ASP.Net to view generated reports in Crystal reports.
• Expertise backend skills in creating SQL objects like Tables, complex Stored Procedures, Views, Indexes, Functions and Triggers to assist data manipulation and data consistency.
• Expert in report writing using SQL Server Reporting Services and in creating various types of reports like Drill Down, Drill Through, Cascading, Parameterized, Matrix and Chart Report.
• Managed documents in SharePoint portal and evaluated basic workflow steps containing actions and no conditions as well as actions with conditions.
• Used SQL Profiler, Execution plan, Performance Monitor and DBCC commands.
• Expertise in Creating Cluster Index and Non Cluster Index, Covered Index, and Indexed View to improve performance on Database side.
• Experience in Dimensional Modeling, ER Modeling using Erwin, Star Schema / Snowflake Schema, Fact and Dim tables and ODS (Operational Data Source).
• Expertise in deploying SSIS Packages and SSRS Reports.
• Excellent skill and strong understanding in Testing SSIS, SSRS, T-SQL objects.
• Flexible, enthusiastic and project oriented team player with exceptional written, verbal communication and leadership skills to comprehend and develop resourceful solutions for demanding client requests.
• Detail-oriented, versatile adaptable in new environment, with strong interest in learning new technologies.
• Ability to work independently and efficiently, managing timelines and expectations.

TECHNICAL SKILLS:

• MS SQL Server 2014/2012/2008 R2/2008/2005
• SSIS, SSRS, SSAS, SSMS
• Microsoft Access 2007/2003/8.0
• Microsoft Word, Excel, PowerPoint, Outlook
• T-SQL
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• MS SQL Profiler
• JavaScript
• ASP.Net, C#.NET
• Business Objects development
• HTML, DHTML, XML, XSL
• Erwin Data Modeler 7.2/4.2/4.1/4.0
• Crystal Reports 8.5
• MS SharePoint Services 2007
• Power BI
• Power Map
• Power Pivot
• Power View
• MS Visio 2003

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Power BI Developer - SQL BI SSIS, SSRS, SSAS

Responsibilities:

• Actively involved in development and implementation of AUM DW, together with the combination of Private Investment, fixed income, equity and Structured Products.
• Designed the base template SSIS packages as a standard for all developers. Worked on SQL Server Integration Services to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, SQL 2008, and Oracle).
• Created SSIS Framework to validate (Column Header, Filename, and Row Count) and Created Report SSIS Framework to generate Custom Excel report based on Business prerequisite.
• Created SSC DW Load SSIS Framework/SSIS Packages to load Incoming SSC files to ODS and ODS to DW after cleansing, scrubbing the data files in combination of complex T-SQL query and SSIS Package.
• Key role in implementing a standardized process for deployment of reports with multiple sub-reports/ linked reports.
• Configured Reporting Manager for subscription, email notification, drill down reports and users security.
• Developed report models for users to create reports on demand.
• Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL Code.
• Performed Quality assurance and testing of SQL server environment.
• Used For-Each Loop Container, Sequence Container, Script Task, Execute SQL task, Variables and Send Mail Task at the Control Flow level and Look-up, Fuzzy lookup, Pivot, Slowly Changing Dimension, Merge Join, Union all, Derived Column, Conditional Split and various other Transformation to manipulate data in SSIS package at the Data Flow level.
• Created Dynamic Package Configuration, Custom Logging, Error Handling, and Notification to SSIS template packages.
• Created packages including extraction from flat files, excel file, oracle and load data to SQL server.
• Created reconciliation reports based on user needs to support security and portfolio third party data validation. Particularly for Barclay’s and Bloomberg’s Point upload.
• Created various AUM and Gain/Loss MTD/QTD and YTD Reports with C# scripting in Script task to handle custom layout and formats of excel sheet.
• Created reconciliation report based on holdings by Portfolio files received from SSC and comparing it with the DW.
• Installed Power BI in VM
• Worked on modeling the data in Power BI involving creating measures, calculating columns, etc.
• Created and managed relationships between tables in Power BI in order to calculate accurate results.
• Transformed and combined the data using Query Editor in the Power BI.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Worked on Power View and Power Map to visualize reports.
• Used Package Configuration to Migrate SSIS package from one environment to other.
• Created SSIS Framework to generate excel report with formatting using Excel Assembly and C# code in Script Task.
• Customized run based on custom report classification schedule table.
• Involved with DBA for various T-SQL Query performance tuning and optimization.
• Used Xml as a data source for SSRS/RDL report creation for Excel Output.
• Developed and implemented various xslt rules. For example: Suppress Total Investment When One Category Level 1 Record exist, Replace Column Header Token Based On Holdings Positive and Negative State, Replace Row Token Based On Positive and Negative State Of Row Data, Remove Empty Formatting Tags and Condense Fair Value Statement.
• Constantly involved with BA to put together production sustain escalation document and RunBook based on Vendor and Client SLAs and easily reached to support 24/7.
• Supporting the entire development process

Tools: & Technologies: MS SQL Server 2012, T-SQL, SSRS / SSIS, Power BI, Win 2008 Server R2, Visual Source Safe, Microsoft Visio 2007, Microsoft Project 2007, XSLT.

Confidential, Newark, NJ

SQL BI /SSIS/SSRS/ POWER BI Developer

Responsibilities:

• Evaluated database population routines (ETL) and ensure quality of production load processes.
• Developed user documentation including help text, report samples, and screen samples.
• Interacted with Business Analysts and Project Managers on a daily basis.
• Reviewed and approved the modification of existing databases and database management systems
• Designed data models using Erwin v4.0. Developed physical data models and created DDL scripts to create database schema and database objects.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Created and managed T-SQL objects such as Tables, Views, Indexes and created complex store procedure using input and output parameter.
• Wrote T-SQL queries using inner join, outer join, and self joins, merge join. And also implemented functionality for removing duplicate records like using CTE and ranking function.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Worked collaboratively with DBA to Improve Performance of the database by creating Stored Procedures, Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Sub-reports, Parameterized, Drill-through, Drill-down reports, Matrix reports and Summary reports in SSRS.
• Installed Power BI in VM
• Cerate Views for Power BI Report and retrieve those views to construct Dashboard report in Power BI Desktop.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Create content pack and publish report on power BI services.
• Coordinated with technical team members, Suggested steps and concepts and created documentation, operational procedures for SQL Server to Netezza migration.
• Migrated all the Views, Tables and Stored Procedures from SQL Server to over to a faster Netezza Server.
• Re-wrote the Stored Procedures for Netezza migration as required since, stored procedure language is significantly different in Netezza.
• Communicated on a weekly basis with team members for a progress status and support services for database migration.

Tools: & Technologies: MS SQL Server 2008 R2, T-SQL, SSRS / SSIS, Erwin v4.0, Win 2008 Server R2, Visual Source Safe, Microsoft Visio 2007, SQL Profiler, Netezza.

Confidential, Warren, NJ

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Created Database objects - tables, views, and functions.
• Rebuilt Indexes and Tables as part of performance tuning exercise
• Set up some tables in the main server as a snapshot publication and push them to the warehouse server (Subscriber) on the nightly basis. This eliminated the old way of emailing spreadsheet on the weekly basis.
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory.
• Successfully implemented physical database design in SQL Server 2008R2.
• Created Indexed Views to facilitate easy user interface implementation and enforce security on critical customer information.
• Wrote Triggers and Stored Procedures and T-SQL Queries to capture updated and deleted data from OLTP systems.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed.
• Generated Drill- through, Drill down, Matrix, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration 2007.
• Integrated reporting environment with a SharePoint product to benefit the using of collaborative environment provided by SharePoint sites.
• Involved with Architect for Data Modelling of Data warehouse.

Tools: & Technologies: MS SQL Server 2008/2008R2, Query Analyzer, SSIS 2008/2008 R2, T-SQL, Excel, SSRS 2008/2008 R2, SQL Server analysis services(SSAS), Windows Server 2003, ERWIN, Visio, SharePoint server.

Confidential, New York City, NY

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involved in Logical, Physical design and Development of the DSR (Data Staging Repository) for the Database and AMS (Asset Management Reporting System) using Erwin.
• Defined Check constraints, Business Rule, Indexes and Views.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Installed and configured MS SQL Server 2008R2 along with Visual Studio on a network domain system.
• Designed develop SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to AMS database.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions and more using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Scheduled Jobs to run SSIS package in night feed to AMS for fresh day data. Load data form AMS database to Data warehouse using SSIS packages.
• 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.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008 R2.
• Defined report layouts, report parameters and wrote queries for drill down reports using SSRS 2008 R2.
• Created parameterized, drill down and aggregation reports using SSRS 2008R2.
• Administered interface to organize, schedule report execution, delivery, and track history using SSRS 2008R2.
• Responsible for the Performance tuning.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Responsible for Backup and Recovery Strategy and Planning.

Tools: & Technologies: SQL Server 2008 R2, ETL/SQL Server Integration Services (SSIS), Management Studio, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor, SSRS.

Confidential, Lansing, MI

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Migrated from SQL Server 2005 to SQL Server 2008.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 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.
• Responsible for performance tuning of existing SSIS packages and introduced dynamic configurations, custom logging, Error Handling etc.
• Created the workflow documents for all existing and new SSIS packages.
• Responsible for Troubleshooting Report Processing, Subscription, Delivery and Configuration
• Designed database objects like indexes, views, user defined functions, triggers, stored procedure, constraints, and roles and documented all the procedures involved in the database for future reference.
• Developed Query for generating drill down and drill through reports in SSRS.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Reported solutions to improve asset management, incident management, system events support and billing.
• Successfully migrated data between heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Created SSIS packages architecting the flow of data from various heterogeneous sources into target.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• Monitored performance and optimized SQL queries for maximum efficiency and implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.

Tools: & Technologies: MS SQL Server 2005/2008, T-SQL, SSIS, SSRS, Import and Export Data Wizard, SQL Query Analyzer, SQL Profiler.

Confidential, Hartford, CT

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 and Oracle 10g using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS packages to Validate, Extract, Transform and Load data to DW and Data Mart Databases.
• Created various Parameterized Reports, Drill through Reports using SSRS 2005.
• Generated ad hoc reports using MS Reporting services.
• Reports were scheduled to be delivered by Email and File. Created Dashboard reports using SSRS.
• Generated reports using SSRS that were used to send information to different Primary vendors, Clients and managers.
• Formed and developed the stored procedures, triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Implemented a well-planned backup and restore strategy that protects databases against data loss

Tools: & Technologies: MS SQL Server 2005, SSAS, T-SQL, SSIS, SSRS, Erwin, MS Access, MS Word