PROFESSIONAL SUMMARY:

• Over 7 years of IT experience on using MSBI tools and MS SQL Server 2012/2008R 2/2008/2005/2000 in OLAP/OLTP environments.
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) and SQL Server data tools (SSDT).
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Experienced in Data Analysis, Data Extraction, Data Profiling, Data Cleaning Research, Reporting
• Good experience in reviewing and understanding business requirements and analyzing and reporting.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Extracted data from internal data warehouse system to SSRS
• Experience in SQL server and database tools like SQL Server Management Studio.
• Perform analysis of the given data and draw accurate inferences, in accord with the objectives of the analysis
• Gather data required to conduct analysis from several sources, compile it together in prescribed format and enter the data in several data analysis software
• Excellent understanding of complete Software Development Life Cycle (SDLC)
• Expertise of data validation using Excel like VLOOKUPs and PIVOT tables.
• Able to meet deadlines while also presenting accurate work
• Excellent understanding of software methodologies like Waterfalls and Agile Scrum.
• Very good experience in Analysis on Web based applications and ETL.
• Excellent Analytical, Decision - Making and Organizational Skills coupled with good co-ordination, communication and interpersonal skills, good Team Player, Quick learner, Self-starter.
• Experienced in Data Analysis, Data Extraction, Data manipulation, Report creation, and Importing & Exporting Data in different formats and from various sources.
• Expertise in data warehousing, ETL programming, and many data warehouse lifecycle tasks such as data analysis, cleansing, transforming, debugging/testing, and loading.
• Proven ability to learn and utilize in-house databases and systems.
• Deadline and Goal oriented - driven to achieve goals both independently and in a team environment. Self-motivated and detail oriented.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2008/R2/2012/2014, Azure SQL Database

Language: T-SQL, Phyton

Tools: Visual Studio, SSMS, SSIS/SSAS/SSRS, Power BI, Tableau, ERwin

Software: Visual Studio, MS Office Suite, SharePoint Designer

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL/SQL Developer

Responsibilities:

• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL work flows to populate fact and dimension tables, and developed Cubes and reports for analysis.
• Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
• Troubleshooting and corrects production ETL issues.
• Optimizing stored procedures, T-SQL, views, and functions for the best performance.
• Refining and automates regular SQL processes, track issues, and document changes.
• Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.
• Developed complex database objects like complex stored procedures and complex UDFs
• Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.
• Developed script for data manipulation and ensuring data integrity.
• Designed, developed and maintained a data warehouse
• Creating Tabular reports with SQL Server Reporting Services (SSRS).
• Generating parameterized reports, drill down drill through reports
• Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.
• Developed script for data manipulation and ensuring data integrity.
• Designed, developed and maintained a data warehouse
• Creating Tabular reports with SQL Server Reporting Services (SSRS).
• Generating parameterized reports, drill down drill through reports
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
• Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.

Confidential

BI/SQL Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
• Worked in conjunction with the data warehouse architect on the development of logical data models.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Extensively used System as well as User-Defined functions to enhance the functionality of my T-SQL code.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created several reports using SSRS like drill through, drill down, linked, parametrized and sub reports and cubes along with its deployment on reporting server with various security measures
• Involved in the design of data marts using star schema and Kimball Methodology.
• Generated and partitioned the cubes and selected appropriate storage modes for the cubes that are used as sources for my reports
• Created queries in SQL Server Management Studio generate reports to verify all Device exceptions within the organization, making sure they are deployed or decommissioned.
• Conducted meetings and email teams to discuss solutions to verify inventory records.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Built and supported the transformation of various data inputs into the enterprise Data Warehouse.
• Implemented enhancements to the current ETL programs based on the new requirements.
• Performed Tuning of the ETL programs to increase the processing and loading efficiency.
• Restricted data for particular users using Row level security and User filters.
• Analyzed & designed solutions, create technical specifications for integration and consult with developers and QA personnel on their tasks related to the imports and extracts.
• Responsible for final work product within assigned projects as related to data, data design, transformations and quality of results.
• Able to extract and manipulate data in a large SQL Server warehouse environment.
• Demonstrated ability to create insightful analytic results and communicate results and methodology effectively with partners.
• Demonstrated advanced excel reporting skills.
• Extensively used SQL for accessing and manipulating database systems
• Profiled source data and pinpointed data discrepancies
• Performed quantitative analysis for financial data and financial statements
• Involved in writing several SQL queries and procedures to provide multiple database services
• Performed data cleansing, data mapping, and data profiling using SSIS

SQL Developer

Confidential

Responsibilities:

• Ensured project requirements and delivery with active interactions with end users.
• Planned and designed data collection and survey tools and performed data analysis.
• Created and tuned database objects such as tables, stored procedures, triggers, views, indexes and joins in MS SQL server to support relational and dimensional databases.
• Developed SSIS packages to Extract, Transform and Load (ETL) data from different sources into database; and to transfer data from various sources including MS Excel, MS Access, Flat Files to SQL database.
• Scheduled SQL Server jobs to load data periodically using SQL Server Agent.
• Created ad-hoc reports and complex enterprise reports such as drilldown, drill through, parameterized and cascading reports using SQL Server Reporting Services.
• Designed and created report templates, plots, bar graphs and pie charts; and scheduled periodical reports to run automatically.
• Documented All MS-SQL database structures and functionalities. Worked with Auditors and Provided Database related documents.