SUMMARY:

• Microsoft Business Intelligence Developer with over 7 years of experience in Banking, Retail, Media (Advertising Marketplace) and Medical domains.
• Expert in Database design, development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.
• Experienced in writing and debugging complex T - SQL queries, dynamic-queries, and other T-SQL constructs.
• Strong understanding in Software Development Life cycle.
• Mapped data from logical data model and physical data model into database objects
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Data Mapping Skills, Data Migration Techniques, Scheduling and Maintaining ETL Framework for different processes.
• Designed and developed reports using SSRS, Power BI.
• Successfully developed business reports using SSRS in deadline-oriented environments.
• Good understanding of SSAS, OLAP cubes and Tabular Model.
• Focused, meticulous and a team-player with great enthusiasm to provide game-changing solutions to client needs while holding excellence in leadership skills.

TECHNICAL SKILLS:

Operating Systems:: Windows 10/8/7/XP, Linux

ETL Tools: SQL server business development studio (BIDS), DTS, SQL server Management Studio (SSMS), SQL server integration services (SSIS).

Analysis and reporting services: SSAS, SSRS, SSAS, Microsoft Power BI, MS Excel.

SQL server Tools: SQL server management studio, Database engine, Import and export wizard

Architecture: Relational DBMS, Client-server architecture, OLTP, OLAP

Version Control: SVN, TFS, JIRA

Big Data Platforms: Amazon AWS, HDFS, Redshift

Other Tools: Autosys CA Workload Automation Tool

PROFESSIONAL EXPERIENCE:

Confidential, New York City

Sr. Datawarehouse/MSBI Developer

Responsibilities:

• Organize stand-ups with Business Analysts, Developers and DBAs to discuss documented initial requirements, access controls and weekly deliverables. Created and assigned JIRAs on weekly sprint.
• Developed ETL process for Gloss to migrate off of existing PRISM data coping with the fluctuating requirements.
• Keeping a track of XML extracts Ftp’d by Broadridge for Gloss into Data Warehouse - Extracts that included trade, position and reference data reports at the End of Day (EOD) and pre-scheduled times throughout the day.
• Developed ETL process to consume EUC extracts (.txt and .csv), perform ELT, load into Datawarehouse and generate output file in elf format.
• Created log tables for Process log, Package log, error log, Number of files and row count.
• Use of SQL Fine Tuning, Performance Tuning and Error Handling Techniques in Pre-Staging and Stage load steps.
• Extensive use of Stored procedures and Execution plans to process and load data into final tables and output Trade, Position, Profit & Loss data for consumption by elf output files.
• Determine the best way to segregate entire EUC process into multiple packages passing disparate project and package level parameters with the best choice of SSIS components considering the Performance and Process consistency.
• Created multiple email alerts based on various conditions (like, load complete/failure, SFTP download error, files archival error) within SSIS and SQL Agent Job.
• Provided Production support after Gloss Go-LIVE and training on Gloss (including EUC Risk Process) to London team with Pre-Process and Post-Completion documentation before signing off.
• Involved in assisting SSRS report re-design in ATLAS project for New York team. Re design included both report level and database level changes.
• Created Automation Process for ATLAS project using Stored Procedures with SQL and HTML scripts with email alerts for various conditions.
• Use of AutoSys CA Automation tool to include the above automation steps and Stored Procedures and schedule to run nightly batch drawing dependencies within AutoSys.

Environment: SQL Server 2017, Visual Studio 2013 and 2015, MS-Excel, AutoSys CA Workload Automation Tool, Red Gate SQL Compare Tool, JIRA.

Confidential - New York City

Sr. MSBI Developer

Responsibilities:

• Coordinated with the technical team to transform the relevant/approved BRD to FRS.
• Worked on modifying table structures for entire loan information using designed index and views to speed up query performance.
• Developed SSIS packages to load data from the flat files pipe delimited and comma delimited to the staging tables and normalized tables.
• Fine-tuned the SQL queries, improving the database performance by 5%.
• Usage of T-SQL to categorize customers according to their assets/wealth to gain loan benefits.
• Developed business logic according to the end client requirements and created SSIS packages.
• Worked on ETL tools to segregate customers records according to benefits acquired depending on their assets.
• Created SSIS packages for Incremental Loading only for Auto Loan data into Data Mart.
• Worked on creating parameterized report summaries on top of fact tables for each loan information.
• Worked on creating reports on excel data by loading data from excel into a staging database using SSIS.
• Created table structures for the process. Generated parameterized reports with static and dynamic pages based on the loan information.
• Used Power BI tools and DAX queries to clean, transform and model raw customer assets related data.
• Used Power BI built-in and custom visuals to create dynamic dashboards for customer loan data.
• Deployed reports to the server and scheduled deployment with subscriptions.

Environment: SQL Server 2014, 2016 Data Tools (SSIS, SSRS), Power BI, MS-Excel, JIRA

Confidential - Secaucus, NJ

MSBI Developer

Responsibilities:

• Involved with Business Analyst to gather requirements and translate requirements to develop strategies and governance practices that help move the business forward.
• Analyze the scope of customers' requirements for data migration projects, design and document solid migration plans and deliver migration services.
• Involved in bulk Data Migration from different sources to SQL Server 2012 as per project needs for data analyzing using SSIS.
• Migrated data from Netezza into staging area and retrieved metadata structure.
• Created views to restrict access to specific rows and columns in tables for security.
• Involved in designing database by applying Stored Procedures and Constraints according to business logic
• Developed ETL using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) from disparate data sources on strong understanding of source and target data structures, ETL processes and Data warehouse schemas.
• Removed duplicate values by creating packages in SSIS using Lookup and Fuzzy Lookup.
• Utilized parameters to configure SSIS packages, improving the migration process.
• Developed Incremental Load using SCD in SSDT Visual Studio to load updated data from clients.
• Design and develop Reports from Data Warehouse using SSRS & SQL Stored Procedures.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS
• Experienced mentoring MSBI interns in the company with the architecture and making familiar with OLTP data.

Environment: SQL Server 2012,2014 Data Tools (SSIS, SSRS), MS-Excel, JIRA

Confidential, New York

MS SQL Server/SSIS/SSRS developer

Responsibilities:

• Worked with business analyst, application developers, business stakeholders to gather requirements, analyze and build solutions with my team.
• Validated and analyzed the data loaded from flat files for decision making purposes.
• Worked on presenting data in charts and tables. Worked on designing the data input.
• Worked on SQL server profiler for improving the performance of present queries, created triggers, created and worked on existing Stored Procedures and Indexes.
• Created various ETL (SSIS) packages to load data from CSV files to the tables in SQL Server with using derived columns to specify the file path.
• Checked the health of the SQL Server.
• Created data mapping documents for ETL process (SSIS). Worked on writing the insert, update and delete queries joining multiple tables to make changes in the staging tables.
• Migrate and upgrade various Oracle versions and patches.
• Designed and created various forms for finance team, sales team and account managers with implementing the business logic. Worked with non-technical teams to help them to use the application.
• Designed the structure of history tables for the finance team

Environment: SQL Server 2012, SQL Server Data tools (SSIS, SSRS), MS Excel