SUMMARY:

• Around 7+ years of experience as a MSBI Developer in implementing Business solutions in Banking, Health Care, Insurance and E - Commerce Industries.
• Involved in all phases of Traditional Waterfall and Agile Software Development Methodologies.
• Experience in Logical and Physical Database design and development, Normalization, Denormalization and Data modeling using Erwin and MS SQL Server Enterprise manager.
• Strong experience in writing complex T-SQL queries which involves multiple Tables using Joins, Views, Stored Procedures, Triggers, Cursors and User Defined Functions.
• Proficient in using SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Expertise in Extracting, Transforming and Loading (ETL) operations in SSIS and worked on Containers, Tasks and developed SSIS packages to load data from different Heterogeneous Data Sources to different Destinations.
• Experience in performing Full Load, Incremental Load with various Data Flow Transformations and Control Flow tasks.
• Experience in scheduling jobs using SQL Server Agent, Proxy Account to automate the process of running SSIS packages.
• Strong Experience in Deploying, Managing and Troubleshooting SSIS packages.
• Strong experience in creating various parameterized, cascading and drill down reports and also created one time requested ad hoc reports for business users.
• Developed various complex reports such as Drill-Down, Drill-Through, Tabular, Maps, Parameterized and Sub reports using SQL Server Reporting Services (SSRS) based on Client requirements.
• Experience in scheduling reports to generate Daily, Weekly, Monthly and quarterly reports using SSRS.
• Expertise in developing Dashboards which includes many sub reports, Maps and Charts using Tableau and Power BI.
• Experience in Troubleshooting SSRS reports, analyzing and implementing new fast running queries to run reports efficiently.
• Experience in developing multi-dimensional Cubes, Calculations, KPI’s using SQL Server Analysis Services (SSAS) and worked in Data Warehouse Environment.
• Created Dashboards, Scorecards using Stack bars, Bar graphs, Scattered plots geographical maps, gnat charts using Tableau with data from warehouse and OLTP database.
• Experience in Data Warehouse designing using Snowflake, star schemas and analyzing various approaches for maintaining different dimensions and facts in the process of building data warehouse management system.
• Having Excellent Communication Skills, Strong Analytical and Problem-solving skills, Self-Motivated, Quick Learner and Active Team Player.

TECHNICAL SKILLS:

Windows XP, 7/8/10, LINUX, T-SQL, PL/SQL, C, C++, C #, SSMS, SSIS, SSRS, SSAS, MS Azure Cloud, BIDS, SQL Profiler, SQL Server 2005/2008/2008 R 2/2012/2014/2016 , Tableau, Power BI, MS Excel, MS Access, TortoiseSVN, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Server/BI Developer

Responsibilities:

• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors using SQL Server Management Studio. Created User Defined Functions, Views to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary.
• Recommend new strategies and architecture to enhance efficiency of data systems. Plan, manage and track database and SQL procedures system changes.
• Create tasks, sessions etc. in the workflow manager and monitored them in the workflow monitor.
• Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.
• Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. For MDM.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked with mappings to dynamically generate parameter files used by other mappings. Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Documented the mappings used in ETL processes including the Unit testing and Technical document of the mappings for future . Designed developed the SSIS packages to extract, transform, load the data into Target and generate outbound files for various vendor by using SSIS.
• Scheduled the Informatica Workflows to start running at specified date and time repetitively forever. Participated in unit testing to validate the data in the flat files that are generated by the ETL Process.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the Tabular, OLAP and Operational data.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Design, develop, implement, and test the automating Infrastructure and Application deployments on AWS.
• Work with AWS engineering and support teams to convey partner and customer needs and feedback as input to technology roadmaps.
• Enabled 25 AWS customers and partners to successfully complete application portfolio discovery work leading to migration of 200,000+ servers and 9000+ workloads to AWS within 2 years.
• Successfully architected an enterprise voice-signaling application as a SaaS solution deployed on AWS, increasing the customer base by 4.5x within the first year.
• Deployed a successful 'High-Performance Computing (HPC)' cluster on AWS for a life-sciences customer and collaborated with HPC software vendor (Abaqus) to optimize the cluster performance
• Standardized application development and testing environments by developing AWS EC2 custom AMI with application software installed & bootstrapping the instances during the boot process to install source code for project teams, leading to 55% reduction in infrastructure expenses year-on-year
• Used Repository Manager to Import/Export Metadata and promote Incremental changes between the DEV/QA/PRD environments. Experience using Metadata Manager for data lineage and Business Glossary to define business terms. Define the roles and access privileges for developer/administrator/data steward/requestor etc. on requirement basis.
• Create the test cases and Test plan for each scenario, perform sanity checks in Dev/SIT and UAT boxes as need basis for Vendor domain.

Environment: MS SQL Server 2017, 2015 Visual Studio 2017, 2015, SQL Server Integration Services (SSIS), SSRS, Data Warehouse, Widows server 2012, AWS, Linux server.

Confidential, Cincinnati, Ohio

ETL/SSRS Developer

Responsibilities:

• Involved in all phases of Agile Software Development, attended all sprint meetings and daily standup meetings, discussing ongoing project and documented the entire requirements.
• Created T-SQL Scripts to develop database objects in staging environment and Created SSIS packages to populate data in Staging environments.
• Worked with various SSIS data flow transformations such as Conditional split, derived column and performed data validation in staging and finally used the developed SSIS packages to load data to data warehouse.
• Implemented Incremental Changes using CDC task to populate changes in OLTP data to data warehouse and store historical summarized data for reporting purposes.
• The Customers data is migrated from different company to our account by the migration process and reports are developed to show business users about our progress.
• Monthly Files are loaded to Vendor Databases and later migrated to our databases using SSIS Packages
• Data validations is done and verified for integrity by removing any data duplicates, errors, and data cleansing is performed before loading to data warehouse.
• Created weekly, monthly and quarterly reports on financial data that was stored on data warehouse and submitted those reports to users for analysis and making decisions on their business scenarios.
• Managed reports in report server by creating snapshots, Subscriptions for user access.
• Designed report templates, bar graphs and pie charts based on data and inputs from various departments and configured scheduling for automatic generation of monthly, weekly, and daily basis reports.
• Developed and implemented Procedures to ensure the quality, usability and accuracy of reports.
• Created Database objects like views, stored procedures, triggers, joins and subqueries on data retrieval and application requirement.
• Worked with Break points, event handlers and check points to debug SSIS packages at runtime to deal with error handling.
• Generated various Ad-Hoc reports using reporting services, excel and tableau.
• Involved in developing dimensions, facts and multi-dimensional cubes, calculations, KPI’s, partitions and retrieving data from OLAP cubes using MDX queries.
• Used multi-dimensional cubes for reporting to analyze summarized and historical data.

Environment: MSBI (SSIS, SSAS, SSRS), SQL Server 2012/2008, TFS, Windows 2007, ERWIN 4.X, Tableau, DTS, Excel Power View, SQL Profiler

Confidential, MA

SSIS/SSRS Developer

Responsibilities:

• Attended meetings with Project Manager, Business Analyst and Team members to analyze business requirements and outlined proposed solutions.
• Worked with different sources, created a pre-staging and staging tables to analyze data before loading into data mart.
• Performed Normalization and De-Normalization on existing tables wherever required for faster analysis from data warehouse and data mart.
• Implemented Incremental Load using Lookup, CDC enabled at database level to make changes in staging and data warehouse data.
• Creates SSIS packages for ETL operations in moving data from OLTP to staging and staging to Data warehouse, Data mart.
• Implemented SSIS packages with logging and event handlers for error handling during package execution.
• Worked with check points, break points in packages for optimizing the performance, handle errors at runtime.
• Reconstructed old ETL packages with new queries and proper transformations for faster data retrieval.
• Deployed SSIS packages by creating SQL Server Agent jobs at scheduled time every Week.
• Generated Parameterized, cascading parameterized, drill down, charts and map reports using SSRS.
• Developed Dashboards using techniques like guided analytics and visual best practices provided by Tableau.
• Implemented ETL Operations in migrating data from Oracle Server to SQL Server and Job runs every day to load data to Our database.
• Worked on all types of transformations available in Power BI Query Editor.

Environment: MS SQL Server 2008/2012, SSIS 2012, SSRS, SQL profiler, TFS, ERWIN 4.X, MS Azure Cloud

Confidential

Jr SQL/BI developer

Responsibilities:

• Involved in all phases of Software Development using Traditional Waterfall method and gathered, documented requirements.
• Created complex T-SQL Stored Procedures, Views, User Defined Functions, Triggers, Cursors, Joins for applications.
• Developed SSIS packages to move data from different source to OLTP Database.
• Scheduled Jobs to run SSIS packages overnight every week and load data in to OLTP database.
• Created Event handlers, break points and check points to debug the package at run time and to handle errors.
• Generated various reports like Drill down, Drill through, Tabular, Matrix, Charts and Maps using SSRS based on Client requirements.
• Used T-SQL views, Stored Procedures as data sources for creating reports to analyze data.
• Loaded data to staging to merge data from different sources before loading to data warehouse.
• Created Various SSRS and Adhoc Reports for supporting ur business and analyst team.

Environment: MS SQL Server 2005/2008, DTS, SSIS 2008, SSRS, SQL Profiler, TFS, TortoiseSVN