SUMMARY:

• Around 3 years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and ETL Developer
• Translated the business requirements into workable functional and non - functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Able to juggle multiple roles on small/medium sized projects from leading the team, data modeling/DBA, and/or development.
• Designed data architecture for one project with cloud computing environment using Amazon Web Services AWS for hosting the databases.
• Developed and documented a Data Strategy Plan, comprising identification of core data, database consolidation plan and data migration plan for Confidential .
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in Design, development of Business Intelligence Solutions using Tableau.
• Good knowledge on Python Collections, Python Scripting and Multi-Threading.
• Developed Spark scripts by using python IDE's as per the business requirement.
• Thorough understanding on connection managers, Checkpoint, Transactions, logging etc.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Teradata etc.
• Exposure in overall SDLC including requirement gathering, data modeling, development, testing, debugging, deployment, documentation, production support.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using p cmd. Extensively used Autosys for Job monitoring and scheduling.

TECHNICAL SKILLS:

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service(DTS), Tableau

SQL Server Tools: QL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS

Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET, C#.Net, SharePoint,Python

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode Flash, Hyper-V Manager

Operating Systems: Windows 10, Windows 2008, 2003R2, Windows Server 2008, Windows XP, Windows Vista, Windows 7

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder

PROFESSIONAL EXPERIENCE:

Power BI/ ETL Developer

Confidential, NY

Responsibilities:

• Transformed business requirements into functional and nonfunctional requirements.
• Created complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.
• Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
• Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
• Designed incremental loads to populate the data mart with checksum and timestamp techniques.
• Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming.
• Implemented package configurations on development, test, and production environments utilizing parameters.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.
• Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.
• Good knowledge on Python Collections, Python Scripting and Multi-Threading.
• Developed Spark scripts by using python IDE's as per the business requirement.
• Implemented python script to perform transformations and loaded the data into Hive.
• Perform thorough unit testing on all relevant platforms to ensure proper implementation.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Created SSAS cubes with KPIs and aggregation for the front-end analysis team.
• Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.
• Designed SSRS reports for in depth business analyses.
• Designed expressions to calculate, group, filter, parameterize, and format report contents.
• Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.

Jr. ETL Developer/ SQL BI

Confidential

Responsibilities:

• Analyzed the source system and involved in designing the ETL data load .
• Developed/designed Informatica mappings by translating the business requirements.
• Worked in various transformations like Lookup, Joiner, Sorter, Aggregator, Router, Rank and Source Qualifier to create complex mapping.
• Involved in performance tuning of the Informatica mappings using various components like Parameter Files, round robin and Key range partitioning to ensure source and target bottlenecks were removed.
• Implemented documentation standards and practices to make mappings easier to maintain.
• Extensive SQL querying for Data Analysis and wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling. Extracted business rule and implemented business logic to extract and load SQL server using T-SQL. nteracted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards to compare the expected weekly registration andphysician specific registrations used dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Prepared different views for Patient Registrations, Doctor Scheduling and Lab Tracking.
• Provided security and user roles for all the users of the various modules
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.