SUMMARY

• Over 5 years of professional experience as SQL database developer /ETL Developer, Data warehousing using MS - SQL Server 2017/2016/2014 MSBI Technologies(SSIS, SSAS and SSRS) and Power BI.
• 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 and Healthcare Services. 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 developing T-SQL queries, 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.
• Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join.
• Experience in Data Extraction, Transforming and loading ETL using various tools such as SQL Server Integration Services SSIS.
• Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.
• 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).
• Experienced in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Experienced in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experienced in Deployment and Change Management through batch scripting and Shell Scripting on different servers and environment.
• Excellent interpersonal 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, SolarWinds 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, NY

SQL/SSIS/SSRS 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.
• 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.
• Used Database Engine Tuning Advisor and monitoring tools for database analysis
• Built 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 workflows 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 support for batch processing and SSIS process using job scheduler.
• Created and maintained documentation for Supported Applications
• Automated the ETL jobs using custom business logic using Power Shell scripting.
• Good working knowledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Make recommendations based on data trends and analysis.
• Generating reports using SSRS in Visual Studio.
• Make recommendations based on data trends and analysis.
• Modified and tuned stored procedures, triggers, views, and indexes to provide best performance.
• Analysed, identified, and implemented user roles and assigned relative database access privileges
• Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.

Environment: MS SQL Server 2017 MS SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, MS SQL Server Reporting Services SSRS, T-SQL, Windows 2016, MS Office 365, Auto sys, Erwin, Microsoft Visual Studio, SQL Server Management Studio

Confidential, Coppell, TX

SQL Developer

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 packages.
• 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 and 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.
• 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 different 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: MS SQL Server 2016 MS SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, MS SQL Server Reporting Services SSRS, T-SQL, Windows 2016, MS Office 365, Auto sys, Erwin, Microsoft Visual Studio, SQL Server Management Studio

Confidential, Houston, Texas

SQL/ETL Developer

Responsibilities:

• Programmed SQL Scripts, Store procedures, Views and Functions and cursors in T-SQL using SSMS.
• Modified and tuned stored procedures, triggers, views, and indexes to provide best performance.
• Worked as a main developer and owned POC of two different AITs for support and maintenance.
• Moult Access databases to SQL Server -designed tables, imported data and applied constraints and indexes ensuring data integrity.
• Upgrading around 55 complex existing SSIS Packages and stores procedures as part of migration from SQL Server 2014 to 2017 POC.
• Transporting data between SQL servers using SSIS.
• Developed Scalable Solutions and providing support on Application Governance and Deliverables.
• 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 projects.
• Worked on Data Mapping and Data Dictionary to create New CRM interface with Wholesale Line of Business.
• Documenting and analysing workflows & use cases, business rules, prototyping, data mapping & data modelling
• 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.
• Developed Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.
• Generated reports using SSRS in Visual Studio for adhoc business requests from Managers.
• Used Database Engine Tuning Advisor and monitoring tools for database analysis
• Involved in database administration principles and practices including security, permissions, and alerts.
• Analysed, identified, and implemented user roles and assigned relative database access privileges
• Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.
• Developing test strategies, test plans based on functional specifications, use cases, and business requirements

Environment: MS SQL Server 2014 MS SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, MS SQL Server Reporting Services SSRS, T-SQL, Windows 2012 R2, MS Office 365, Auto sys, Microsoft Visual Studio, SQL Server Management Studio

Confidential

Jr. SQL Developer

Responsibilities:

• Co-ordinate with team members on resolving migration issues using migration tool.
• Involved in Planning Defining and Designing data based on business requirements and provided documentation.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Migrated DTS Packages into SSIS packages.
• Used SSIS and T-SQL stored procedures to transfer data fromOLTP databases to staging areaand finally transfer into data warehouse
• Designed and Configured an XML file for passing dynamic parameters to SSIS packages.
• Created Jobs, Alerts, SQL Mail Agent, and schedule SSIS packages.
• Worked on system objects and DMVs to handle performance issues.
• Build, Configuration, Packaging and Deployment.
• 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.
• Experience in Generating Report Models, Refining and Enhancing the Report Models, Deploying Report Model, Creating Reports on Report Models
• Maintain, support and document for future migration tasks.

Environment: MS SQL Server 2012 MS SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, MS SQL Server Reporting Services SSRS, T-SQL, Windows 2012, MS Office, Microsoft Visual Studio, SQL Server Management Studio