SUMMARY

• More than 5 years of experience in analyzing, designing, developing, and deploying Database, ETL work flows and Data Warehouse systems using Microsoft SQL Server and SQL Server Integration Services. Highly experienced in Data modeling (till 3NF normalization level) and Dimensional modeling (using Star and Snowflake schemas), Business Intelligence using MS SQL Server and Power BI in Banking & Financial, Healthcare and Service industries.
• Extensively involved in all phases of software development life cycle (SDLC) and experience in Agile / Scrum and Project Management Methodologies.
• Experienced in Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications. Have strong experience in reverse engineering the back-end code.
• Extensive experience in Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS).
• Experienced in SQL Server Database design developingT-SQLqueries,function,stored procedures and triggers using SQL Server and update database.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Strong experience in logical and physical database design and development, normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Have excellent command writing ad hoc queries utilizing dynamic SQL. Strong Transact-SQL query writing skills (DDL, DML, TCL, DQL and DCL).
• Expert in Data Integrity, Performance Tuning, Query Optimization and Validation issues.
• Highly experienced in Dimension modelling using star and snowflake schemas, handling Slowly changing dimension using different techniques like row hash (MD5 and SHA), Slowly changing dimension wizard and Lookup, especially in incremental load of data.
• Implemented Full, Incremental and Remigration ETL workflow and data pipelines for Staging, Data mart and Data Warehouse databases.
• Designed and developed ETL SSIS process design, architecting the flow of data from various sources to target.
• Experienced in SSIS utilities like Import/Export Wizard, Package ISPAC Installation ISDEPLOYMENT Wizard, and SSIS Package Designer.
• Developed SSAS Cubes (Dimensions, Hierarchies, Dimension Usage Relation Ships and Measure Groups), Also developed Cube deployment strategy through XMLA file, Processing through SSIS package and SQL Agent Job.
• Experienced in implementing Key Performance Indicators (KPIs) Objects in SSAS.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving, and extracting data for reporting using SQL Server Reporting Services (SSRS)/Power BI.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Excellent experience in migration of data from Excel, Flat file, Oracle, Data Lake, hive tables to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Migrated DTS Packages to SSIS using various versions of SQL Server.
• Good experience on PL/SQL programming at developer and designer level.
• Experienced in Deployment and Change Management through batch scripting and Shell Scripting on different servers and environment.
• Experienced on production support for different applications including third party applications.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server databases and scheduled them according to requirements.
• Experienced in installing, configuring, managing, monitoring and troubleshooting on different version of SQL Server including 2016/2017
• Experience in usingInformaticaClient tools: Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Excellent inter personal and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS

Databases: MS SQL Server, Oracle, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe and MS Access

Database Tools: Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Replication, SoalrWinds DPA, Aqua Studio

Reporting Tools: SQL Server Reporting Services(SSRS), Crystal Reporting, Power BI, Tableau

ETL Tools: SQL Server Integration Services(SSIS), Data Transformation Services(DTS), BCP, Business Intelligence Development Studio (BIDS), Informatica ETL

Analytical Tools: SSAS MultiDimensional and Tabular Model

Languages/Scripting: T-SQL, DB2, PL/SQL,VB.NET, C#, Shell Scripting, Unix, Linux

Web Technologies: Web Services, XML, HTML

Applications: Microsoft Windows Enterprise, MS Visual Studio, Lifepro, MS Office, TFS, Sharepoint

IT Processes: Software Development Life Cycle (SDLC), Agile, Scrum, Waterfall

Data Modeling: MS Visio, ERwin, FACT & Dimensions tables, Physical & Logical data modeling and De-normalization

Scheduler: CA Workload Automation Workstation (ESP), AutoSys, SQL Agent

PROFESSIONAL EXPERIENCE

Confidential, Arlington, TX

SQL/ETL Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.
• Involved in Change/Release Management process for deployment of change on Prod Environment and server maintenance and server patching on regular basis.
• Worked on Electronic Data Integration, Claim processing and Payment.
• Programmed T-SQL to create database objects such as tables, stored procedures, views, and triggers and to generate reports in SSRS and Power BI.
• Developed T-SQL programs to create database, programmed queries, sub-queries, ranking functions, derived tables, common table expressions, stored procedures, views, user defined functions, constrains and database triggers using T-SQL.
• Optimized stored procedures and long running scripts using execution plan, temp tables, and code rewriting and indexing strategies to increase speed and reduce run time.
• Build the SSIS package to load data into Staging ODS by writing optimize SQL queries for integration
• Utilized SSIS containers/transformations such as Sequence container, Foreach loop container, Look up transformations, merge joins, derived column with multiple Data flow task. To pull data sources like SQL server, Oracle, Excel, and Flat files
• Developed SSIS package to load data from different data source by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Implemented various Error Handling and Event handling techniques in SSIS to ensure smooth and efficient package execution
• Deployed the run of SSIS package to the conversion server and automated the run of the packages on a weekly basis by creating and scheduling SQL server Agent jobs.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Documented ETL projects and work flows by using Bi Documenter and including supporting documents for troubleshoot for each project.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Created data sources and data source views DSVs, named calculations and names queries calculated members, named sets, KPIs, drill through, report actions and perspectives as per the business requirement.
• Developed multiple Enterprise reports using SSRS from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and include various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.
• Provided suport for batch processing and SSIS process using job scheduler.
• Created and maintained documentation for Supported Applications
• Created, Configured of different ESP APPLS as per the requirement of QA & Dev team and providing support facility by debugging and fixing the issues.
• Provided L2/L3 Technical Support for Batch Processing and SSIS package through ESP automation with 24×7 on-call support including holidays and weekends
• Guided & trained offshore consultants on proving Support in ESP Automation, debugging and fixing production issues mainly on SSIS Packages, SQL codes and Stored Procedures.
• Worked on Cross functional teams to proactively address product issues.
• Conducted Code reviews and adhere to Change control methodologies acrossUAT, Prod environments.
• Worked on data collection, data analysis, data cleaning, performance tuning,troubleshootingand debugging using SSMS.
• Checks sessions and error logs and also used debugging for complex Problem troubleshooting.
• Planned, Defined and Designed data based on business requirement and provided documentation.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent and ESP Automation tools.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2016

ENVIRONMENT: AND APPLICATIONS: MS SQL Server 2016/17, Windows 10, SSIS, SSRS, T-SQL, Oracle, SQL Server Data Tools, MS Office Suite, Power BI, Power App, Tableau(basic), TFS.

Confidential, Charlotte, NC

SQL Developer (SSIS/SSRS )

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models.
• Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other database objects as per the business requirements
• Assisted on the Ad hoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in tables for wholesale lending to different merchant banks Developing Power BI report using Power Apps Entity data and other Databases.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.
• Developed SSIS packages to Push and Pull data using Rest APIs and other different sources and vendors.
• Built SSIS package to load data from different files and databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot, Slowly Changing Dimension and other transformations from different sources.
• Used different type of Transformations for Data Conversion, Sorting, and cleaning the data from different sources into Company format.
• Created Package Configurations, Event Handlers for On Error/Warning/Task Events.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Troubleshooted and monitored daily execution and implementing enhancement on existing SSIS packges.
• Maintained the physical reports by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
• Provide support to junior co-workers and work with offshore resources for knowledge share.
• Doing peer/ code review of co-worker abd junior developer and make necessary revision to make sure code best practice has been followed and to eliminate errors into PROD environment.
• .Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2014.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Created and updated data into CRM and providing support.
• Worked on Upgrading and automating manual jobs and scripts into SSIS and scheduled in sql agent.
• Used diffetnt types of files like XML, JSON to load the data into sql database using ZappySys .
• Developing test strategies, test plans based on functional specifications, use cases, and business requirements
• Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modelling

ENVIRONMENT: AND APPLICATIONS: Windows 10, MS SQL Server 2014 -SSMS, SSRS, SSIS-SSDT, MySQL, MS Office Suite, MS Excel

Confidential, TX

Jr. SQL Developer

Responsibilities:

• Worked as a Subject Matter Expert for couple of AITs of Mortgage and Vehicle Service Operation Technology.
• Writing SQL Scripts, Store procedures, Views and Functions and cursors in T-SQL using SSMS.
• Working as a main developer and poc of two different AITs for support and maintenace.
• Creating Scable Solutions and providing support on Application Goverance and Deliveriables.
• Building and Maintaining SQL Scripts, Indexes, Store procedures, Views and Functions and cursors.
• Developed and optimized Store procedure and function using T-SQL scripts for Vehicle and Mortgage projects .
• Worked on Data Mapping and Data Dictionary to create New CRM interface with Wholesale Line of Business.
• Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modelling
• Developed SSIS packages pulling data from Hadoop, Teradata and other sources.
• Built SSIS package to load data from different files and databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot, Slowly Changing Dimension and other transformations.
• Upgrading around 150 complex existing SSIS Packages and stores procedures of vehicle & Mortgage Service.
• Develped new process to pull the data from Hadoop and Teradata into SSIS and provide report to LoB.
• Upgraded and automated manual jobs and scripts in to SSIS and scheduled in sql agent.
• Prepared Production support documents for new process and updating documents for existing process for Production Support
• Troubleshooted and monitored daily execution and implementing enhancement on existing SSIS packges.
• Worked on Debugging and Fixing of failed SSIS jobs.
• Developing test strategies, test plans based on functional specifications, use cases, and business requirements
• Used SSRS to create, customized, On-Demand and Ad-Hoc reports and involved in analyzing multi-dimensional reports inSQL Server Reporting Services.

ENVIRONMENT: AND APPLICATIONS: SQL Server 2012, SSIS, SSAS, SSRS, BIDS, ETL, T-SQL, MS Excel, MS Access, MS Visio