SUMMARY:

• As a Certified developer having 10+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000 in Development, Test and Production Environments with various business domains.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQLServer Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Published reports to Azure based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack and Apps).
• Excellent hands on experience in groups, hierarchies and measures, KPIs.
• Extensive use of DAX (Data Analysis Expressions) functions in creating Power BI dashboards, reports and Tabular Models.
• Proficient in the ER - Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types using T-SQL.
• Experience in creating functions, Logon triggers, cursors, indexed views, temp tables, dynamic SQL, CTEs, SQL code commands.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance
• Expertise in SQL Server 2008 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and online analytical transactional processing (OLTP) data mining functionality for business intelligence applications
• Strong expertise in using ETL Tool Informatica Power Center 8.x/9.x/10.0 (Designer, Workflow Manager, Repository Manager and ETL concepts.
• Designing and developing Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions (SCD)
• Experienced in using advanced concepts of Informatica like push down optimization (PDO).
• Validating data files against their control files and performing technical data quality checks to certify source file usage.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
• Worked Extensively on ETL process using SSIS package. Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
• Experience in databases like MySQL and NOSQL like MongoDB.
• Experience in MongoDB installation, patching, troubleshooting, performance, tracking/tuning, back - up and recovery in dynamic environments.
• Experience in managing life cycle of MongoDB including sizing, automation, monitoring and tuning.
• Experience with complex data environments.
• Generated Tableau visualizations and dashboards using tableau desktop. Generated Dashboards with Quick filters, parameters and sets to handle views more efficiently.
• Strong Confidential and Management Skills with excellent role-playing capabilities.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica PowerCenter 9.6.1/9.1/8.6 , (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server).

Databases: Oracle 11g/10g/9i/8.0, Greenplum PostgreSQL),,, MySQL, SQL Server 2005/ 2000/2008 Programming SQL, PL/SQL, Unix, Shell Scripting

Tools: TOAD, SQL Developer, Hive, Hbase, Pig, Sqoop, Map Reduce, pgAdmin, agility,autosys Data Analysis

Requirement: Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential - St. Louis, MO

Responsibilities:

• Installation, configuration and maintenance of MS SQL Server.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.
• Rewrote the existing code for long running queries by replacing cursors with various joins, common table expression (CTE).
• Created SSIS Packages using Pivot Transformation, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data to Excel Spreadsheets.
• Created SSIS packages to get data from various sources (DB2, Oracle).
• Worked with Team foundation server (TFS) offering source control, data collection, reporting, and project tracking.
• Populating a database with new information or transfer existing data into it.
• Creating backup copies of data.
• Daily maintenance of firewall protection and file security.
• Development of web based interfaces for Oracle databases and web applications.
• Responsible for database security and also preventing data loss
• Perform quality assurance and testing of SQL server environment.
• Provided support by troubleshooting and solving the issues.
• Performance Tuning of SQL Server Databases.
• Managing SQL Server security and logins.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures applying to complex business scenarios.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

SQL Developer

Confidential - Auburn Hills, MI

Responsibilities:

• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• 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 SQLtask to insert transaction log data into the SQL table.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the querie
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Developed Query for generating drill down and drill through reports in SSRS.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.
• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse.

Environment: Microsoft SQL Server 2012, T-SQL, SQL SSIS, SSAS, SSRS, SQL Profiler, Visual Studio 2008, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net

SQL Developer

Confidential - Scottsdale, AZ

Responsibilities:

• Developed PL/SQL triggers and procedures, functions, packages to provide backend security and data consistency.
• Involved in documenting user requirements, technical specifications and Reporting manuals.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Developing functional, technical documents, advanced coding and bug fixation.
• Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing.
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented using Forms, Reports, PL/SQL, Flex fields and Workflow.
• Customized, created and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Designed and developed custom database security in PL/SQL for Oracle versions 9i, and 10g.
• Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQLNavigator, Crystal Reports, TOAD.