SUMMARY:

Confidential is a green card holder that has over 7 years of experience as an ETL/BI developer. He has extensively used SSIS and SQL Server over the last 7 years and has created numerous end - to-end solutions for his clients. His s and technical assessment speak extremely highly of both his technical and non-technical skills. On top of this, his communication and personal skills are outstanding. He recently finished his last project and is open to interview and start work immediately.

TECHNICAL SKILLS:

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 Experience: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage

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

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Machine learning Skills: R, Python

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

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Data Engineer/Scientist

Responsibilities:

• Conducted different EDO team meetings to understand and analyze business problems and data.
• Worked in administrative role to set up Watson Studio Local in DEV, UAT, and PROD environments for complete SDLC.
• Established a dataflow for Data Scientists which includes Talend and Watson Studio Local.
• Set up a secure process for open source Python/R packages install on WSL On-Premise servers.
• Performed Machine Learning to analyze and predict revenue vs customer group. The process includes Classification and Clustering techniques.
• Generated concise data from DB2 database using case statements, joins, coalesce function to perform Machine Learning.
• Created interactive Tableau Dashboard to display revenue trend out of customer groups and published on server.
• Identified, analyzed and fixed variety of issues on Watson Studio Local, Docker and Kubernetes to maintain well working environment for Data Science teams.
• Wrote Python script to automate process of configuring user account in WSL.
• Built Python packages to audit query execution in Jupyter Notebook.
• Worked on integrating TabPy in Tableau which facilitates creating more advanced calculated fields.
• Helped team members to understand written Python code.
• Educated best practice of doing Data Science, Reporting and Data Movement to Data Science teams.
• Worked with platform team and received Tableau site admin .

Tools: & Environment: Talend, Tableau Desktop, SQL, Linux, Watson Studio Local, AQT (Advanced Query Tool), RStudio, Jupyter notebook, Python, R, Spark, Machine Learning, Docker, Kubernetes.

Confidential, Scottsdale, AZ

SQL/SSIS Developer

Responsibilities:

• Collaborated with the design architect and business analyst to outline business requirements in JRD meetings.
• Developed and designed automated solution using stored procedures for business users in order to load data directly to tables.
• Developed SSIS packages to migrate data between OLTP servers and the data mart.
• Enhanced performance of SSIS packages with different properties and adapting best practices for OLAP system.
• Debugged SSIS packages with data viewers and breakpoints for testing purpose.
• Managed the execution and security of SSIS packages on the Integration Services Server.
• Implemented error handing techniques such as try catch and error functions to create a robust T-SQL code.
• Redesigned and improved existing procedures, triggers, UDFs, and views with execution plans, SQL Profiler, and DTA.
• Created stored procedures to implement data profiling, data validation, and verification.
• Published reports to Power BI service and pinned tiles from reports and Q&A to create dashboards.
• Prepared various visualizations with the help of Power BI Desktop to gain more insights and trends on business process.
• Created complicated reports such as parameter-based reports, graphical reports, drill-down and tabular report using SSRS.
• Created design specification documents for the new reports developed through SSRS.
• Worked with report snapshots, linked reports and used report manager for deploying reports in SSRS.
• Deployed Team Foundation Server (TFS) for the version control and project co-ordination.

Tools: & Environment: SQL Server 2016, Erwin, T-SQL, SQL Profiler, SSIS, SSAS, SSRS, SSMS, SSDT, Power BI, TFS, DTA

Confidential, Wayne, PA

SQL/SSIS Developer

Responsibilities:

• Analyzed business requirements, facilitated planning and implementation phases of the data mart via JRD meetings.
• Created and maintained logical model for the project including documentation of all entities, attributes, and data relationship.
• Created SSIS packages to develop jobs for extracting, cleaning, transforming and loading data into data mart.
• Performed data cleansing, validation, and verification with SSIS transformations and SQL stored procedures.
• Implemented logic for incremental load deploying checksum and timestamp techniques in SSIS.
• Created database objects such as UDFs, indexed views, clustered, and non-clustered indexes.
• Utilized system functions such as string, date, mathematical and created user defined functions to meet business requirement.
• Optimized queries by modifying T-SQL queries and eliminated redundant data.
• Developed visually-rich charts, maps, slicers, word cloud, funnel, gauges utilizing Power BI, delivering actionable insights.
• Identified KPIs such as Revenue per lawyer, Hours billed, Client growth rate, and Client retention for performance analytics in Power BI dashboards.
• Formulated dashboard SSRS reports server projects and published SSRS reports to the reports server.
• Generated sub-reports, drill down reports, drill through reports and parameterized reports using SSRS.
• Collaborated with the team utilizing TFS to synchronize data with various sources.

Tools: & Environment: SQL Server 2012, Erwin, T-SQL, SSDT, SSIS, SSRS, SSMS, Power BI, MS Excel, TFS, DTA

Confidential, Cincinnati, OH

MSBI Developer

Responsibilities:

• Gathered system requirements through end-user collaboration through JRD and JAD meetings.
• Designed the technical specifications document for ETL processing of data and strategized the integration test plan and implementation.
• Created the enhanced logical model using ER/Studio and the various relationships between the entities.
• Designed multiple database objects such as stored procedures, UDFs, and temp objects as per the business logic.
• Implemented error handling techniques such as system variables and try-catch in SQL.
• Prevented potential blocks and deadlocks with the help of complex code and isolation levels.
• Designed data mappings between sources and staging targets utilizing star schema.
• Designed and developed SSIS packages for data cleansing with transformations such as fuzzy lookup, lookup and data conversion.
• Built complex SSAS cubes with fact measures groups and multiple dimension hierarchies.
• Formulated reports with multiple options with report designer and report builder in SSRS.
• Formatted SSRS reports with parameters and embedded functions with expressions.
• Enabled snapshots, subscriptions, and report caches for enhancing response times and reducing traffic to the report server.

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

Confidential, West Des Moines, IA

BI Developer

Responsibilities:

• Analyzed multiple user requirements and development specifications for OLAP applications in JAD meetings.
• Designed OLAP data model using Star-Schema with the use of design software such as Erwin.
• Established joins and created indexes whenever necessary, based on requirements.
• Created complex stored procedures for data profiling, data manipulation, and report generation with SSMS.
• Created triggers and stored procedures to enforce business rules via checks and constraints.
• Designed SSIS packages with synchronous and asynchronous transformations to make data clean and consistent.
• Monitored and configured SSIS packages for dynamic execution; deployed packages to the testing environment.
• Optimized ETL packages by increasing memory buffer size and parallel processing of packages.
• Involved in the troubleshooting of several package and solved several issues related to execution, development and performance in SSIS.
• Designed SSRS reports with conditional formatting and implemented interactivity utilizing bar, pie and several charts.
• Developed report backup and delivery schedules by configuring subscriptions and snapshots respectively.

Tools: & Environment: SQL Server 2008 R2, Erwin, T-SQL, SQL Profiler, SSIS, SSRS, SSMS, BIDS, MS Visual Studio, MS Excel, TFS

Confidential, Kansas City, MO

SQL Developer

Responsibilities:

• Participated in JAD meetings and outlined functional requirements to design the data migration process.
• Gained exposure in database design, normalization, selective de-normalization, conceptual, logical and physical data modeling using Erwin.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the application team and reports team during development.
• Contributed in the profiling of legacy database tables using T-SQL queries in order to provide data cleansing issue reports to the client.
• Worked closely with the application developers to help determine any issues with SQL script, SQL server performance, normalization, security and database/server connectivity and database schemas.
• Deployed SSIS packages into an MSDB database on the production server.
• Worked with SQL Server Reporting Services SSRS to author, manage, and deliver both paper-based and interactive web-based reports.

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