SUMMARY:

• 8 years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation, and Deployments using SQL Server 2016/2014/ 2012/2008/2005 & Oracle 11g, 12c.
• Strong experience in Business Intelligence (BI) using Visual Studio 2010/2008/2005.
• Created, Built, and deployed successfully dynamic SSIS packages into SQL Server /2008/2005 databases and scheduled them according to requirements.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Experienced in TSQL (DDL, DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2008/12/14
• Experienced in relational database design, SQL queries, Stored procedures, Functions, clustered, non-clustered indexes and indexed, views, Performance tuning,
• Experienced in Importing/Exporting Data from various data sources like Excel, and Flat file using DTS utility and SSIS services.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Extensive experience in creating enterprise reports using SSRS 2008/2012 using Report Manager, Report Builder, and BIDS
• Created many Drill Through, Drill Down, Parameterized reports using SSRS 2005/2008
• Excellent knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
• Have hands-on experience in Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks.
• Creating and deploying parameterized reports using Power BI and Tableau.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Excellent communication skills, bridging Client Interaction and a Team player. Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem-solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little training.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012/2008/2003/2000

Windows 8/7/Vista/XP: Languages

T-SQL, PL/SQL, C#, .Net, VB.Net, ASP.Net, XML, HTML, Java Script: Tools /Utilities

Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development Studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2012/2008/2005, SQL * Plus, Toad, Erwin, Power BI Tivoli Work Scheduler, Tidal, JIRA.: Databases

MS SQL Server: 2016/2014/ 2012/2008/2005, AWS, Oracle11g/10g/9i, DB2, MS Access, MySQL.

Data Modeling Tools: Microsoft Visio, UML, Erwin, Oracle Enterprise Management OEM

Software: MS Office, DTS X Change, Adobe Photoshop, MS Excel, MS-Project 2000

Reporting Services: Hyperion Financial Reporting Studio, Excel, SQL Server Reporting Services, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

ETL/SQL/ BI / Developer (SSIS/SSAS/SSRS/FRS)

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Working on Financial Reporting Studio and Crystal Reports
• Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008 Integration Services (SSIS).
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 OLAP databases.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Involved in project planning, scheduling for database module with project managers.
• Generated database monitoring and data validation report in SQL Server Reporting Service (SSRS).
• Generated various reports with drill downs, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Developed tabular models for reporting, come up with a design based on requirements and volume of data whether to develop SSAS OLAP cube or tabular model.
• Deployed the SSRS reports in Microsoft office share point portal server.
• Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
• Wrote an optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Created Star Schema for OLAP cube generation and extensively worked dimension modelling for analysis service using SSAS.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks, and indexes configurations.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Environment: MS SQL Server 2016/2014/2012, SSAS, DTS, Windows 7, Visual Studio 2010/2013, SQL Server Business Intelligence Development Studio(BIDS), SSRS, TFS, MS-Visual Studio 2010, MS Access, XML.

Confidential, Dayton OH

ETL Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Built different data visualization by using Power BI to turn data into charts/maps.
• Delivered required Power BI report as internet link, embedding in Office Tools.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Developed and optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Developed SSIS packages to validate, Extract, Transform and Load (ETL) data into Data Warehouse and Data Marts using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Conversion.
• Managed and developed existing and new ETL processes for SQL Server reports. Refreshed staging tables with ETL. Scaled SSIS to make it work more reliable.
• Built SSIS ETL packages for processing fact and dimension tables with transforms and Slowly Changing Dimensions (SCD) to ensure the database platforms are configured, hardened and maintained to capture record changes.
• Developed SQL Server Integration Services (SSIS) ETL Packages and other back-end processes to support system integration and ETL processes to facilitate the creation and population of the Enterprise Data Warehouse.
• Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).
• Built up high performance ETL package for migrating different data source into target database, cleaning and backing up data, and synchronizing daily transactions by using SSIS.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
• In the staging phase of the ETL process, used lookup tables and fuzzy lookup tables to handle data cleansing and validation.
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.
• Performing Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and built high performance ETL packages to migrate and manipulate data from Oracle, MS Excel, and SQL server by using SSIS.
• Expert in Database Normalization, Optimization and Tuning. Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.

Environment: MS SQL Server 2014/2012, SSAS, DTS, Windows 7, Visual Studio 2010/2013, SQL Server Business Intelligence Development Studio (BIDS), SSRS, Power BI, TFS, MS-Visual Studio 2012, MS Access, Tableau,XML.

Confidential, Pittsburgh, PA

MS SQL Server /SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Project-manage Oracle MDM implementations for Oracle customers.
• Developed Custom Logging so the user can know when a row is inserted in custom logging table by every SSIS package that executes if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• 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 SSIS Packages to move data from one database of a server (Partner) to another (CRM) using DBAmp pro tool
• Wrote 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.
• Responsible for creating partition function and schema for the table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period.
• Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Created Excel to SQL, SQL to SQL, and Flat File to SQL ETL packages using SSIS in Visual Studio.
• Created for each loop containers and conditional splits to load data.
• Transferred data to SQL database in SSMS using ETL packages.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Environment: Microsoft SQL Server 2012, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Visual Source Safe 2005, C#, SQL Profiler.

Confidential, Smithfield, RI

SQL/SSIS/SSAS/SSRS Developer

Responsibilities:

• Created SSIS packages to migrate data from different data sources to the data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from a development server to production server.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• 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 2012.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Environment: SQL Server 2012, SQL Server BI Development Studio (BIDS) 2012, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server.

Confidential, Karachi, Pakistan

MS SQL Server Developer

Responsibilities:

• Involved in Gathering end-user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Composed user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions
• Involved in database design, normalization, de-normalization in building a data warehouse and reporting systems.
• Involved in query tuning by creating clustered and non-clustered indexes on tables, and used index tuning wizard.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre-execute, post execute and error.
• Involved in package logging in both standard (SQL server and file-based ) and custom logging using customer stored procedure and tables.
• Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using detect utility, command prompt with .bat files etc.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, pdf, MS word and excel formats using SSRS (2005/2008).

Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL profiler, SSIS, SSRS, SSAS, Windows Server 2003/2008, C#, .Net, Visual Studio 2008, MS Access.