SUMMARY:

• Over 6 years of experience in IT as a SQL Developer with specialized skills in SSIS, SSAS, and SSRS.
• Experience in managing security of SQL Server 2016/2012/2008 R2/2008/2005 databases by creating database users and roles, and assigning proper permissions according to business requirements.
• Strong SQL Server 2016/2012/2008 R2/2008 development skills including writing stored procedures, user - defined functions, triggers, views, and indexes.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL).
• Excellent command of writing ad hoc queries utilizing dynamic SQL.
• Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Expertise in creating reports of all types in SSRS, like ad hoc, drill-down, pivot, and tabular reports.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Experience using SSIS tools like Import/Export Wizard, Package Installation, and SSIS Package Designer.
• Strong experience in defining referenced relationships and identifying KPIs in SSAS 2008/2005.
• Designed rich Dash Boards with Power BI and Prepared user stories to create compelling dashboards to deliver actionable insights.
• Used power BI Desktop to connect various data sources and worked with different visualizations and created dash boards.
• Imported data from SQL server DB, Azure SQL DB to Power BI to generate reports.
• Wrote DAX Expressions, Power query, Functions in Power BI

TECHNICAL SKILLS:

Operating systems: Windows XP/Vista/7/2008R2

Databases: SQL Server 2005/2008/2008 R2/2012/2016, Access

Database tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS),SQL Data Tools, EDI

ETL tools: DTS, SQL Server Integration Services, SQL Server Analysis Services, EDI Kit

Reporting tools: SQL Server Reporting Services (SSRS), Crystal Reports

Development skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.NET, ASP.NET (C#)

Application packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

SQL/ETL/SSIS/SSRS Developer

Roles and Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Involved in the data analysis and database modeling of both OLTP and OLAP environment.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like Conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2016 and unit test SSIS load processes for performance check.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.

Environment: SQL Server 2014/2012 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access & Windows Server 2008R2, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint.

Confidential, Chicago, IL

SQL/ETL/SSIS Developer/Data Warehouse

Roles and Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Created the SSIS packages and scheduled them using SQL Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized Event Handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index TuningWizard.
• Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.
• Extracted data from XML to SQL server.

Environment: SQL Server 2008R2 Enterprise Edition, .Net 3.5, SQL SQL Server Data tools (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Confidential

SQL Server/SSIS/SSRS/SSAS Developer

Roles and Responsibilities:

• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Enforced business rules with checks and constraints
• Involved in code review and code review meetings
• Conversion / Migration of SQL Server 2005 to SQL Server 2008
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints
• Involved in migration and conversion of Reports from SSRS
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Created cubes, dimensions, measures and calculated measures according to the requirements
• Deployed and processed Cubes on a weekly basis to update information using SQL Server Agent
• Built MDX Queries using SQL Server Analysis Server (SSAS) 2008
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation