SUMMARY

8 years of strong IT experience with comprehensive business/technical skill set and expertise in requirements analysis, design, software development, process improvement, systems integration, workflow design, business process automation/management, project management, process modeling, data analysis, data quality, unit testing/quality assurance, security, deployment, and maintenance.

• Extensively used SSIS, SSAS & SSRS for various BI requirements. 
• Excellent in writing SQL queries for both data validation and data extracting.
• Has extensive experience in developing External Tables, Stored Procedures, Functions, Packages, Views, Cursors and Database Triggers.
• Having good experience in database administration such as designing data - model, implementing relation-ships, handling security issues, importing and exporting database, managing table-spaces.
• Experienced in solving business problems, gathering data, transforming databases, performing research analysis against data warehouse and then data interpretation in reports and publications.
• Experienced in data analysis and developing of ETL packages and scripts using SSIS.
• Expert in designing high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experienced in designing, developing, coding and implementing applications and generating forms, reports and dashboards using SSRS.
• Knowledge of developing cubes in SSAS and Analyzing Dimensions and Measures.
• Experienced in Cube designing to create shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Admirable capability of performance tuning, normalization, partitioning of data and indexing of partitioned tables.
• Experienced in data modeling using Rational Rose and Erwin.
• Having excellent communication, great inter-personal, organizational skills and have professional attitude and ethical approach.
• Sincere, well-organized, quick learner, self-motivated, team player and achiever.
• Taking responsibility for own work, capability to adapt and learn new tools and applications, ability to attain a high degree of accuracy and neatness in work presentation and excellent capability to handle multiple projects.
• Greater flexibility with work hours and/or extended hours on occasions.

TECHNICAL SKILLS

• SSIS: SSRS / SSASData Analysis: Data Quality
• Data Profiling: Data Cleansing
• Data Mining: Data Scrubbing
• SQL: T-SQL
• Agile / Scrum / Waterfall SDLC: DTS (Data Transformation Services)
• MS SharePoint: Microsoft Team Foundation Server (TFS)
• Cubes: Security
• Scorecards: SQL Server Management Studio
• SQL Query Analyzer: SQL Server Profiler
• Rational Requisite Pro: Clear Case
• Clear Quest: Oracle
• DB2: Microsoft Visual Studio
• Datawarehouses (EDW): Datamarts
• OLAP | OLTP | SCD | CDC | Schemas: Dashboards
• BI Reports: ETL Packages

PROFESSIONAL EXPERIENCE

 Confidential, Arlington, TX

Sr. SQL Server Developer (MS BI)

Responsibilities:

• Analyze data and performed system requirements gathering tasks all the way down to documenting specific data models.
• Determines database requirements for projects and ensures that new systems comply with database strategies.
• In charge of submitting change requests and work requests and also actively followed up the status of the requests with other teams and also managers for approvals.
• Documented the list of enhancements that needs to be performed on the system and prioritized them accordingly after meeting with the customers and users.
• Provide day-to-day technical support in maintaining the systems, including responsibility for ensuring processes and outputs are complete and error-free.
• 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/2014).
• Set Customer best practices expectations revolving around MDM.
• Advise Oracle MDM usage and design to best fit customer business process requirements.
• Developed Custom Logging so 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.
• 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, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
• 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.
• 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.
• 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, linked reports and dashboards using SSRS.
• Created various jobs using SQL Server Agent.
• Created dashboards, KPIs and scorecards using MS SharePoint.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Worked on performance by tuning SQL code and table structure of various processes
• Performed data profiling and modeling to find out the data quality, how the new project can utilize the data and risks associated with it
• Performed unit and system testing and reviewed the test results with other team members.

Environment: Agile, Microsoft SQL Server 2012/2014, SQL, T-SQL , SQL Server Management Studio, Microsoft Visual Studio, VB.Net, MS Visio, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS) Visual Studio 2010/2008, SQL Server Agent, Erwin, SQL Profiler, Microsoft SharePoint 2010 .

Confidential , Seattle, WA

MS BI Developer (SSIS | SSRS | SSAS)

Responsibilities:

• Interacted actively with business users, participated in the project meetings gathered business requirements and created project plan documents.
• Maintained active relationships with business users to determine business requirements and gather more information about the project.
• Interpreted and implemented the Visio flowcharts using tools such as Enterprise Manager Query Analyzer incase of SQL Server and Toad in case of Oracle. Then use this data in appropriate tools like MS Access to generate reports.
• Created technical documents for data mapping and database migration.
• Developed and designed the whole process to load data into Data Warehouse (DWH)
• Involved in designing the data model for the Data warehouse tables.
• Created the list of enhancements and issues, prioritized them and worked on making the changes
• Involved in creating partition function and schema for the table partitioning.
• Responsible for creating SSIS packages to load the data into Type 1 and Type 2 dimension tables and created SSIS packages to load the data into Fact tables after transformation.
• Created the Date Dim to keep the track of Start Date and End Date.
• 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 of time.
• Used script task to update row counts and insert row counts for the Type 2 Dimension tables.
• Wrote C# scripts in the script task to calculate the final update and insert row counts for the table. Used XML Configuration to make the package dynamics.
• Used SQL server table for logging of the SSIS packages and maintain the details of the run time and rows affected and update row counts and insert row counts.
• Implement Event Handlers and Error Handling in SSIS packages and notify process results to various user communities.
• Test, Clean and Standardize data meeting the business standards using Fuzzy/Exact lookups using SSIS tasks.
• Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cube as backend and provided integration between MS Excel/SSRS and SSAS.
• Extensively involved in the SSAS storage and partitions, aggregations, calculation of queries with MDX, Data Mining Models and developed cubes using MDX and SSAS 2008.
• Convert Actuate reports to SSRS reports using SQL Server Reporting Services.
• Applied various features in SSRS to get the same reports as Actuate reports.
• Maintained the documentation for the all reports to keep track of users of the reports and to get sign off from them to move the developed reports to Production.
• Performed quality assurance checks and update databases to ensure data integrity.
• Performance optimization of the data warehouse by identifying and assisting in BI performance bottlenecks and debug database, application or data content related issues.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Environment: Microsoft SQL Server 2008R2, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, Microsoft Visio 2007, MS Access, Excel.

Confidential, Chicago, IL

Job Title: ETL Developer (SSIS) / Report Writer (SSRS)

Responsibilities:

• Responsible for gathering requirements for the database designing for the middle office with the Data Architect. Involved in understanding the current system and analyzed the overall compatibility of the all systems with the proposed Middle Office Database design.
• Created new database schema and tables for the Middle Office.
• Involved in creating new and modifying the existing stored procedures and functions.
• Cleaned the data using SQL Server Integration Services (SSIS
• Created reports using SQL Server Reporting Services (SSRS) as per user requirements.
• Deployed reports and configured security and subscriptions for the reports.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Created User Defined Tables (UDT’s) and used for the creation of stored procedures.
• Involved in creating Indexes and tuned the performance of SQL Queries.
• Used various SSIS transformations for loading the data into the Middle Office tables.
• Created table driven configuration for SQL Server Integration Services (SSIS) packages.
• Designed various reports like chart, drilldown, drill through and matrix reports based in the user requirements using SQL Server Reporting Services (SSRS
• Developed reports in SSRS 2008 R2 and deployed reports into SharePoint Server 2010.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Followed agile methodology and delivering fast iterations to the users.
• Used Visual Source Safe (VSS) to check in the project work to maintain the version control.
• Created various jobs using SQL Server Agent.
• Generating ad-hoc reports using MS-Excel and SSRS.
• Extensively used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report Server.
• Automated and updated daily tasks on IT Service Management System (ITSM)
• Documented project works and processes.

Environment: Microsoft SQL Server 2008R2, SQL Server2008,T-SQL, SSIS, SSRS, Embarcadero, Visual Studio 2008, SQL Server Agent, Windows Server 2008, Visual Source Safe 8.0, SQL Profiler, SharePoint 2010, Team Foundation Server(TFS), Jira, C#, Erwin, MS Access.

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Design, develop ETLs and Reports using Microsoft SQL Server BI Suite and was also responsible for data migration.
• Responsible for developing and deploying SSIS packages and scheduling the packages, setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Imported data from text files and excel spread sheets into SQL Server 2008 using SSIS package.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Involved in creating views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPIs) in SQL Server 2005 Analysis Services (SSAS) using ProClarity and published via Windows Share Point Services.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: Microsoft  SQL Server 2000/ 2005, T-SQL,  SSIS , SSRS, SSAS, Erwin, Windows server, Microsoft Office Share Point Server, Visual Source Safe, SQL Profiler, Visual Studio, Waterfall  

 Confidential

Jr SQL Developer/SSRS/T-SQL

Responsibilities:

• Created reports using SSRS while identifying the data source and defining them to build the DSV’s.
• Created queries for generating drill down and critical drill- through reports in SSRS
• Generated Reports using global variables, expressions and functions for the reports
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Developed complex SPs, triggers, cursors, tables, indexes, constraints, views and other SQL joins for applications
• Responsible for deploying the reports and maintaining their performance

Environment: SQL Server 2005, SSRS, T-SQL