SUMMARY

• Over 6 years of experience in the IT industry and currently working as a OLTP Developer.
• Skilled in developing and implementing best practices in creating BI solutions.
• Experience in SDLC for the design, development and staging phases of the projects with support of Data - Flow, Process Models, and ER Diagrams.
• Merit of working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale data warehouses using SSIS.

TECHNICAL SKILLS

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX, Python, R

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

OLTP Developer

Responsibilities:

• Conducted meetings with stakeholders throughout the development phase to gather system requirements from users and ensure user acceptance testing was performed.
• Performed various operations such as data cleansing, data scrubbing, and data profiling.
• Developed the dimension model for proposed OLAP system and designed the data flow.
• Designed and optimized dynamic SQL batches to perform bulk operations in the OLTP environment.
• Created complex views and materialized views on multiple table as per customer requirement.
• Utilized T-SQL constructs such as joins, subqueries, derived tables, and views for querying data.
• Optimized queries by modifying T-SQL queries and eliminating redundant data.
• Customized the reports and applications with using SQL server techniques.
• Developed SSIS packages to extract data from sources such as SQL Server OLTP and Excel.
• Optimized issue resolution procedures for large-scale production environments in SSIS.
• Designed ETL strategies to populate the data warehouse/data-mart with facts and dimensions.
• Incorporated error redirection during ETL loads in SSIS Packages.
• Developed data migration applications to retrieve and populate data from Azure Table / BLOB storage to on premise SQL Server instances.
• Reviewed changes in SSIS packages, reports, cubes, and database objects with Team Foundation Server (TFS).

Tools & Environment: SQL Server 2016, SSIS, SSMS, SSDT, T-SQL, Erwin, TFS, SQL Profiler, DTA, MS Azure

Confidential, San Diego, CA

SQL/OLTP Developer

Responsibilities:

• Collaborated with the design architects and business analysts to outline the business requirements in JRD meetings.
• Implemented tables, relationships, creating stored procedures, and views.
• Participated in the testing of applications for performance and data integrity.
• Analyzed complex requirements, procedures and translated them into SQL.
• Understood and wrote complex SQL independently and performed impact analysis.
• Implemented indexes on OLTP/OLAP tables to improve navigation performance within large datasets.
• Successfully developed standardized procedures for common SQL tasks and troubleshot SQL queries and common database issues.
• Optimized the performance of T-SQL queries and SSIS packages.
• Analyzed source OLTP systems and created data mapping documents for the ETL process
• Understood the existing ETL and relational database framework and scheduled packages using SQL Server Agent Jobs.
• Worked for Performance Tuning and Query Optimization.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the staging data base.
• Created ad-hoc queries and reports as requested and provided on-going support to fine-tune and evaluate queries for improving performance and efficiency.
• Created various reports such as drilldown, drill through, and chart with reporting services.
• Created, validated and reviewed solution and effort estimation for data migration to Azure cloud environment conducting proof of concept for latest Azure cloud-based services.
• Managed different versions of code with Team Foundation Server (TFS) to support project coordination.

Tools & Environment: SQL Server 2012, Erwin, SSDT, SSIS, T-SQL, MS Excel, TFS, DTA, MS Azure

Confidential, Philadelphia, PA

SQL/ETL Developer

Responsibilities:

• Worked with Business Analysts and understood the business requirements and came up with system design.
• Reviewed, evaluated, designed, implemented and maintained organizational databases.
• Identified data sources, constructed data decomposition diagrams, provided data flow diagrams and documented the process.
• Wrote codes for database access, modifications, and constructions including stored procedures, triggers, functions, synonyms, and so on.
• Optimized database and ensured the integrity of data repositories.
• Scheduled and maintained jobs including database backup maintenance plans.
• Developed a multitude of database objects in T-SQL.
• Designed and deployed various SSIS packages for different databases.
• Tested the ETL process for both before data validation and after data validation process.
• Developed drill through, drill down, linked, sub, and parameterized reports for improved analysis.
• Designed and deployed various SSRS reports for different databases.

Tools & Environment: SQL Server 2012, T-SQL, SSIS, SSRS, SSMS, SSDT, SQL Profiler, Erwin, DTA

Confidential, Edison, NJ

SQL Developer

Responsibilities:

• Analyzed data requirements and application and processed architectures, data dictionaries, and database schema(s) and recommended design and improvements.
• Developed code modules and logic to process corporate data and support batch processes.
• Wrote objects such as stored procedures, functions, DDL/DML triggers, and indexes with SQL/T-SQL.
• Designed, developed, amended, optimized, and certified SQL and other database schema design to meet system requirements.
• Developed SQL or other types of database and warehousing designs across multiple platforms and computing environments.
• Developed an overall data architecture that supports the information needs of the business in a flexible but secure environment.
• Created configuration files to deploy the SSIS packages across all environments.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Implemented report deliveries and backup schedules with subscription configurations and snapshots.
• Collaborated with business analysts and developers to identify requirements and design the reporting application.

Tools & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSIS, SSRS, SQL Profiler, DTA, TFS

Confidential, New York, NY

Database Developer

Responsibilities:

• Gathered, analyzed, and normalized relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.
• Worked with a small team of ETL developers on specific projects, including working directly with senior managers and clients.
• Developed mapping specifications, Source to target mappings and ETL development.
• Developed the workflow and dataflow of SSIS ETL processes to support various different file structures and business processes.
• Performed tasks related to performance tuning of ETL jobs.
• Worked on data loading workflow design and custom enrichment development using leading ETL tools
• Created a multitude of reports and dashboards with SSRS.
• Managed report delivery schedules by configuring standard/data driven subscriptions within the Report Manager.

Tools & Environment: SQL Server 2008, T-SQL, SSMS, BIDS, SSIS, SSRS, SQL Profiler, DTA, TFS