SUMMARY

• Over 5 years of extensive experience in database design and development using MS SQL Server 2016/2014/ 2012/2008
• Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Expert in Data Modeling and Multi - Dimensional Modeling
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.
• Excellent knowledge on RDBMS principles.
• Proficient in using Power BI
• Proficient in MS SQL Server suite of products like TSQL, SSRS and SSIS of MS SQL Server.
• Proficient in creating SQL Server reports, handling sub reports, and defining query for generating drill down reports using SSRS.
• Maintained existing reports and created new reports according to the business needs and integrated them in performance point server.
• Experienced in using global variables, expressions, and functions for the reports.
• Maintained securities, roles, subscriptions in report manager in SSRS.
• Expert in designing SSAS cubes with slowly changing dimension, partitions, Aggregation and KPIs
• Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating subquery sections etc.
• Extensive experience of writing complex T-SQL queries, Views, Triggers, Functions and Stored Procedure
• Developed complex reportsusingSSRS and deployed into MSCRM.
• Experienced in migrating reports from Crystal Enterprise to SSRS.
• Experienced in managing Tableau driven dashboards and reports
• Extensive experience in creating SQL Server analysis projects using MS SQL Server.
• Experienced in creating complex SSIS and DTS packages for ETL purposes.
• Implemented complicated transformations to be used in SSIS packages.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
• Competent in MSDynamicsCRM, C#, XML, Fetch XML, HTML5, CSS, JQuery and JavaScript, SQL Server,SSISand SSRS.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity, SQL joins and query writing.
• Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
• Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
• Migration of data from Excel source toCRMusingSSIS.
• Highly motivated and competent individual with good communication and analytical skills.
• Creative and passionate for technology.
• Good team player, extremely adaptable and a fast learner.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio (2012/2014/2016/2017 ), Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Teradata SQL Assistant

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SSRS (2014/ 2012/2008/2005/2000 ), MS Access, MS Excel, Crystal Reports, Tableau Desktop, PowerBI

Database: MS SQL Server 2012/2008/2005/2000 , MS Access, Oracle 11g/10g/9i

Programming: T-SQL, PL/SQL, C, ASP.NET 4.5/4.0/3.5, C#.NET,Vb.net

Web Technologies: HTML, DHTML, XML, XSL, Java Script, CSS

Operating Systems: Windows 2003/2008 Server, Windows XP, Windows 7,Windows 8,Windows 10

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Toad, Accurev, GITHUB

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

SSIS/Power BI/Sql developer

Responsibilities:

• Responsible for creating and designing SSIS packages.
• Using Azure data warehouse for storing the data
• Generating reports though power BI application
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose server through various ways
• Created projects by two ways one is package deployment
• Written some C# coding for automatic loading ofmetadatato SQL tables and mapping documents.
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Worked with APS appliance for the Order Analytics Repository
• Deployed reports onto the production and QA and project deployment
• I also converted one project from package deployment model to project deployment model.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, sql server)
• Created Script task for calling the web services using Vb script by Postman
• Used PowerBI to compare data from one server to other server
• Prepared the data mapping for all the migrated jobs using SSIS
• Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance in order to tune them
• Responsible for Development of the scripts (Perland Shell) needed during the Data Migration phase of the project.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain themetadata, Security and Reporting
• Worked with Microsoft experts for creating packages.
• Created SSIS packages using CRM Dynamics
• Created script to migrate SQL server object from one environment to another environment
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
• Modified the queries to achieve better performance
• Designed ETL process using SSIS to extract data from flat files, excel files and SQL server database
• Built complex stored procedures in Azure and on APS
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance
• WrotePerlscripts to automate manual activities.
• Worked on TFS for performing tasks
• Used Accurev and Github for code repository

Environment: MS SQL 2008 R2/2012, SSIS, Azure, PowerBI, APS, XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS, Accurev, GITHUB, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Team Foundation Server, FTP & SFTP server. Perlscripting

Confidential, Houston, TX

MSBI / SSIS /SSRS / SSAS SQL Developer

Responsibilities:

• Responsible for creating and designing SSIS packages.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Design SSRS and excel reports, expense analysis, and balance sheet analysis.
• Deployed reports onto the production report server through various ways
• Worked on managing Tableau driven dashboards and reports
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Developed complex reportsusingSSRS and deployed into MSCRM.
• Prepared the data mapping for all the migrated jobs using SSIS
• Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance in order to tune them
• Created SSIS packages using CRM Dynamics
• Created script to migrate SQL server object from one environment to another environment
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
• Modified the queries to achieve better performance
• Designed ETL process using SSIS to extract data from flat files, excel files and SQL server database
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Worked on migration of SSIS 2008 packages to SSIS 2012
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
• Involved inTabular Data warehouseandDAXoperations for SSAS 2012 and 2008 OLAP databases.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.
• Wrote Python/Perlscripts to parse XML/JSON documents and load the data in database.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, Ms CRM,VBA (Visual Basic for Applications), Share point, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential, Houston, TX

SQL Server/Data Ware House/ ETL Developer

Responsibilities:

• Wrote MDX queries to access data from OLAP cubes in SSAS. Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Developed logical and physical data models, designed data access strategies, and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Worked on all theAzurecomponent production deployments and management.
• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• I created a virtual machine onAzure, installedSQL2012, created and administered databases then loaded data for mobile application purposes using SSIS from another virtual machine.
• Created Source Target mappings for migrating on-Premise DataMart toSqlAzure.
• Migration process done from SQL server 2012 to Azure cloud
• Experience withSQLAzureDatabase Performance Tuning
• Automating daily activities withPerland Metadata
• Extensive use ofDAX expressionsin tabular models as per business requirements.
• Experienced in using Data Analysis Expressions DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Involved in Writing SQL Queries, Views, and Stored Procedures on SQL Server 2005.
• Designed databases for applications with requirements for large numbers of transactions, heavy access, and high availability.
• Backed-up enterprise databases toAzurestorage in block BLOBs and backpack files inAzure environment.
• Optimized T- SQL code.
• Worked with Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin

Environment: T-SQL, MS SQL Server 2005, MS Azure, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005,MS SQL Server Reporting Services 2005, DAX, PowerPivot.

Confidential, Los Angeles, CA

SQL Server SSIS/SSRS/ETL Developer

Responsibilities:

• Worked with business stakeholders, application developers, and productions teams and across functional units to identify business needs and discuss solution options
• Gathered requirements from business users
• Agile methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints
• Developed and deployedSSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing Foreach Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimensionand more
• Performed ETL mappings using MS SQL Server IntegrationServices
• Implemented Event Handlers and Error Handling in SSIS packages
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases
• Supported Production Environment by schedule the packages and make the package dynamic with SQL Server Package Configuration
• Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job
• 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
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS)
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS
• Involved in table and indexpartitioning for performance and Manageability
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance

Environment: MS SQL Server 2008, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer

Confidential

SQL Developer

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Development of T-SQL Stored Procedures for moving and maintaining synchronization of data between legacy system and newly developed application.
• Expertise in using variables, property expressions, and script tasks in SSIS Integrated Database Maintenance jobs to perform full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Documented and maintained history of changes for future .
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL.
• Assigned Index tuning scripts to run at regular intervals.
• Performance monitoring and tuning MS SQL Server.
• Assisted the Application team in data modeling and T-SQL coding.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, Microsoft Office, Windows 2003/XP.