SUMMARY

• More than 5 years of experience in analyzing, designing, developing, and deploying Database, ETL workflows and Data Warehouse systems using Microsoft APITERADA and SQL Server Integration Services Highly. experienced in Data modeling (till 3NF normalization level) and Dimensional modeling (using Star and Snowflake schemas) in various domains.
• Extensively involved in all phaSASses (system analysis, design, development, testing, and implementation) of software development life cycle (SDLC) and experience in Agile / Scrum and Project Management Methodologies.
• Expert level skills in Data Mapping, Normalization, Batch jobs, Troubleshooting, Data migration, Data collation, Data cleansing, Entity Relationship Design (ERD) model and application - oriented design.
• Experience in Performance Tuning and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans
• Used Informatica in SQL to execute in source database and the results can be pulled by the PowerCenter.
• Proficient in T-SQL programing and have implemented SQL Query constructs, Sub Queries, User Defined - Functions, Stored Procedures, Triggers, Views, and materialized views. Proficient in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Highly Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC.
• Experienced in creating Database Objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default) Views and Indexes.
• Expertise in writing T-SQL Queries, Complex Stored Procedures, creating Triggers, Cursors, User-defined functions, Joins and Common Table Expression (CTE).
• Hands on experience in administration tasks like installing, configuring, upgrading, log shipping, troubleshooting, scheduling, partitioning, backup & recovery, transaction logs.
• Proficient working experience with SQL, stored, Database objects like Stored Procedures, Functions, Views, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables.
• Generating SQL and PL/SQL scripts to install create and drop Trading Exchange Connection database objects including Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Experience in Query Tuning by Using Execution Plan, query analyzer and tuning advisor.
• Experience in creating Jobs, Alerts and scheduling SSIS Packages in SQL Agent.
• Expertise working with SQL Server 2012/2016/2014 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
• Experience in design of ETL packages using SSIS for integrating data from heterogeneous sources (Excel, Flat File, Oracle, Access, DB2, Xml format) using multiple transformations.
• Expert in creating SSIS packages for ETL processes using control flow tasks like Execute SQL Task, Data Warehouse Management, Execute Package task, etc. and data flow tasks like Derived column, Slowly Changing Dimension, Look up, Conditional Split, OLEDB command, etc.
• Designed ETL workflow to load data into Staging / Landing, Data Mart / Data Warehouse databases for full, incremental and remigration of data.
• Proficient in Dimensional modeling, defining dimension attributes, hierarchies and different types of fact tables and measure granularity.
• Strongly experienced in creating SSIS packages with Error handling, Logging, Package configurations and by implementing Break Points, and Check Points as well.
• Experienced using various methods to Execute SSIS packages and deploying through different modes.
• Possess excellent skills in Data Modeling using Star and Snowflake Schemas.
• Experience in designing and building the Dimensions and cubes and Deploying and Processing cubes using SQL Server Analysis Services (SSAS).
• Experience in working with large volume of database and storage modes like ROLAP/MOLAP/HOLAP.
• Experienced in Designing, Developing, and processing of cubes usingSSAS. Created and Configured Data Sources and Data Source Views, Cubes and calculated measures forOLAPcubes.
• Experienced in generating on-demand (ad-hoc) reports for business analysis or management decision using SQL Server Reporting Services and Report Builder.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports.
• Experienced in developingPower BIreports and dashboards from multiple data sources, publishing, and scheduling Power BI reports.
• Experienced with DAX calculations, composite modeling, Direct Queries, Data modeling, etc. on Power BI. Expertise in using advanced level calculations on the data set.
• Advanced proficiency in MS Office applications (Outlook, Word, Excel, PowerPoint, Visual Basic).
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS

Database and Data Modeling Tool: ER Studio, Microsoft Visio

SQL Server Tools: Microsoft Visual Studio 2013/2017, SQL server Management Studio

Business Intelligence: Power BI, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Programming Languages: SQL, T-SQL, PL/SQL, C#.Net

Operating Systems: Windows, Windows Server 2016/ 2012 R2/ 2012, UNIX

Other Tools/Skills: HTML, CSS, XML, Advanced Excel, Data Analysis, DAX, Power Query M, Data Analysis

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables.

PROFESSIONAL EXPERIENCE

Confidential, Lewisville, TX

SQL/ETL Developer

Responsibilities:

• Interact with various Business Analysts, Management, and IT Units to analyze business & functional requirements, Convert business requirements into technical use cases.
• Responsible for preparing high level and low-level design documents for change requests and bug fixes.
• Involved in requirements gathering, analysis, design, development, change management, and deployment.
• Translated business requirements into BI application designs and solutions.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Designed tables and views structure for the application. Define DDL and accordingly build the table structure.
• Upload the table into related databases and upload it in respective project in GIT.
• Good exposure in creating and managingconceptual, physical, and logicaldata models.
• Normalized tables and maintained Referential Integrity by using Triggers, Constraints and keys.
• Programmed T-SQL code for stored procedures, managing tasks and meeting deadlines in response to ad-hoc requests.
• Involved indesigning and implementing relational database RDBMSmodel as per business needs.
• Responsible for developing, support and maintenance for theETLExtract, Transform and Load processes usingSQL Server integration services.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Tuned SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL Packages, mentor others with the creation of complex SQL Statements, perform data modeling and create/maintain and modify complex database Triggers and Data Migration scripts.
• Designed and developed Dimensional modeling i.e., Fact table and Dimension tables using SNOWFLAKE schema.
• Extracting data fromIMS/DB2, MS Access, SQL Server for migration and performing various transformations in SSIS ETLper business rules.
• Designed Data flows, Workflows, and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and developed the OLAP systems for data mart applications using SQL Server Analysis Services.
• Designed and built OLAP cubes to meet reporting needs.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Designed Cubes with Star Schema using SQL Server Analysis Services. Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services.
• Implemented process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Configured integration services and reporting services for developing new environment for NPS systems New Application.
• Converted existingDTS packages to SSIS ETLand tune the connections pointing towards new applications.
• Used change data captureCDCto simplifyETLin data warehouse applications.
• Experience in creating jobs, alerts, SQL mail agent andschedule SSIS ETL packages.
• Configured Connection Manager files forSSIS packagesto dynamically execute on QA server and Production server.
• ExperienceType 1 SCD and Type 2 SCDmappings to updateslowly changing dimensiontables. Experience pulling data fromSSAS cubeand developing and maintaining cubes.
• Experience in configuration of report server and report manager scheduling, give permission to different level of usersin SQL server reporting services.
• Performs System testing for all the modules and helps business inUser Acceptance Testing.
• Worked on generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.
• Utilized tools like SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.
• Coordinating with offshore teamfor on time delivery of products and query resolution activities.

Environment: SQL Server 2016, 2014, 2012, Windows 2012 Server, Data Modeling, Data Architecture, Visual studio 2017, Visual Studio 2013 (For Reports), Oracle GGS, Service Broker, Tableau, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), Share Point, MS Access

Confidential, Sacramento CA

SQL/ETL Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Developed the database for operational objectives by studying business rules, gathering information, evaluating output, and clarifying requirements and formats.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Convert Access databases to SQL design tables, import data and developing constraints and indexes ensuring data integrity.
• Developed tables, views, indexes, functions, and advanced queries for databases.
• Programmed complex stored procedures, functions, cursors, and SQL joins for applications.
• Implemented new SQL features likeChange Data Capture CDC,Transparent Data Encryption TDEand Policy based Management.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Created Indexes and maintained fill factor for fast and efficient reporting process.
• Utilized SQL Server Profiler to monitor for long running queries and tune them to improve performance.
• Utilized Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub queries with JOINS to enhance the performance of Databases.
• Utilized tools like SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.
• Involved in designing and implementing relational database RDBMS model as per business needs.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using SQL Server 2014 integration services.
• Extracting data from IMS/DB2, MS Access, SQL Server 2014/2016 for migration and performing various transformations in SSIS ETL per business rules.
• Designed SSIS packages utilizing tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Send Mail Task, Foreach loop Container, Derived Column, Conditional Split and Derived Column.
• Utilized Script Task to write Vb.net or C# code to satisfy business rules.
• Created packages with error handling and used package configurations for deployment.
• Developed packages to send email alert and log into SQL table for any issues (on error).
• Configured XML config files (.dtsconfig files) to change properties of packages dynamically.
• Generating reports using SSRS in Visual Studio.
• Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services SSRS.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services. worked in developing parameterized reports, linked reports, Snapshots, Drilldown and Drill through reports using SSRS
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.
• Experience in working with Confidential global clients and customers and handling high priority production issues.
• Maintained database instances, creating various database objects, Synchronizing Production and UAT environments.

Environment: MS SQL Server 2014, T-SQL, Data Stage. MS Access, MS SQL reporting Services, Microsoft Visual Studio 2016, SharePoint Designer, SQL Server Management Studio, Windows Server 2012 R2.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, and deployment.
• Involved in complete Software Development Lifecycle (SDLC).
• Reviewed, analyzed, and implemented necessary changes in appropriate areas to enhance and improve existing systems.
• Converted Access databases to SQL design tables, import data and developing constraints and indexes ensuring data integrity.
• Developed complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Advised optimization of queries by looking at execution plan for better tuning of Database.
• Performed Normalization & De-normalization on existing tables for faster query results.
• Programmed T-SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.
• Modified and tuned stored procedures, triggers, views, and indexes to provide best performance.
• Analyzed, identified, and implemented user roles and assigned relative database access privileges
• Use Database Engine Tuning Advisor and monitoring tools for database analysis
• Make recommendations based on data trends and analysis.
• Exposure to database administration principles and practices including security, permissions and alerts.
• Involved in Development of ETL data flows using SSIS; created mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.
• Developed SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server.
• Involved in Development of SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Designed and developed different types of reports like matrix, tabular, chart reports using SSRS.
• Involved in migration on SQL Server 2012 databases to SQL Server 2014.
• Maintained positive communication and working relationship with all business levels.
• Coordinating with onshore/offshore & stake holder’s team for task clarification, fixes, and review.
• Developed Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.
• Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.

Environment: MS SQL Server 2012, Erwin, MS SQL Integration Services, MS SQL Reporting Services, SQL Analysis Services (SSAS), MS Excel, Windows Server 2012

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction o bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules
• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions
• Tuned several slow running queries in Production. Implemented Indexes to achieve time Performance.
• Developed Data-data packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL server, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Scheduling and Maintaining SSIS Packages and batch jobs thru SQL Server Agent and using Shell Scripts, VB Script and batch .bat files on a day-to-day basis
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Worked on Transforming and Loading data using SSIS,Import/Export wizard.
• Developed Enterprise reports using SQL Server Reporting Services SSRS and Excel pivot tables based on OLAP Multidimensional cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill Down Reports, Dashboard, Cascading, and charts using SSRS.
• Interacted with Developers in troubleshooting application and Report Developing.

Environment: SQL Server 2012 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MS Project, MS Access & Windows Server 2012, Oracle.