Sr Bi Etl Developer Resume
Franklin, TN
SUMMARY:
- Over 7+ years of analysis, design, development, documentation, implementing and testing experience in IT industry by building enterprise application solutions using SQL BI suite of products technologies.
- Having 6+ years of experience in SQL Server Query programming by writing complex Stored Procedures, Views and Triggers.
- Having 5+ years of experience in utilizing SSIS and SSRS tools for addressing the daily data needs and reporting needs of data warehouse and transactional applications.
- Having 2+ years of experience in C# .net coding experience, supporting the ASP .net applications.
- 1+ years of hands on experience with Power BI analytical tool by creating dashboards, visualizations and data modeling.
- Experienced in all phases of Waterfall, Agile, and Iterative Enhancement SDLC methodologies.
- Strong in SQL Server development and Optimizing SQL server objects like Stored Procedures, User - Defined Functions, Triggers, Views, and Indexes to improve the performance of SQL server objects for faster query results.
- Experience in Shell Scripting for scheduling jobs, server setup and file processing.
- Proficient in SQL Server Integration Services (SSIS 2017 Latest) development by developing efficient ETL/ELT processes with less maintenance needs.
- Expert level experience in processing all types of Homogeneous and Heterogeneous data transfers into/from SQL Server and Extensive experience in Data Migration between homogeneous & heterogeneous systems using SSIS and various other tools (Import/Export).
- Expertise in SQL Server reporting services (SSRS 2017 Latest) in generating complex reports like Dash b oard Reports, Parameterized Reports, Cascaded Parameterized Reports, Drill Down and Drill Through Reports, Ad Hoc reports.
- Extensive experience in Automotive Manufacturing, Banking financial and HealthCare domains.
- Effectively performed various job roles such as Module Leader, Developer, Analyst, Tester and Training multiple fresher’s in the project
- Extensive experience in data warehouse design by developing Fact and Dimension tables and establishing relationships using Star Schema and Snowflake Schema models for satisfying the business data needs of enterprise analytical reporting.
- Extensive experience as Business Analyst in gathering requirements from the Business users and translating the requirements into Business requirement documents (BRD) and Functional requirement documents (FRD).
- Effectively performed QA Analyst responsibilities as tester to validate data generated by ETL tools and to perform peer reviews.
- Excellent communication skills, fast learning, hardworking, adaptability and a very good team worker with interpersonal communication and analytical skills.
- Strong sense of ownership on projects and excellent skills in creating project standardization documents.
TECHNICAL SKILLS:
Languages: SQL and PL/SQL, ASP.net, Batch file programming, C,C++, C# .net, XML and EAI Patterns
RDBMS: MS SQL Server 2017/2016/2014/2012/2008 , MS Access 2007/2010/2013 , Oracle
Web Technologies: CSS, XML, HTML, DHTML, JSP, JavaScript, XSL, and XSLT
BI Tools & Technologies: SQL Server Integration Services (SSIS) 2008/2012/2014/2016/2017 , SQL Server Reporting Services (SSRS) 2008/2014/2016/2017 , Power BI, Tableau 9.X
O/S: Windows 2010/2012 Server, 7/10
Messaging Services: MQ, Message Broker, See Beyond JMS and Standard IQ
Other Tools: Visio, UltraEdit-32, WS FTP, F-Secure SSH, SQL Developer, IBM i Navigator, Toad, One Note, Excel, Task Factory(ETL), OPCON job scheduler
Source Control: TFS, Microsoft VSS, Red Gate, SVN,GIT
Testing tools: HP Quality Center
Ticketing Tools: Service Desk Express, Service Now, Jira
PROFESSIONAL EXPERIENCE:
Confidential, Franklin TN
Sr BI ETL Developer
Responsibilities:
- Analyzing existing Healthways applications in Oracle environment and recreating oracle packages and stored procedures as per the data delivery requirements of Confidential .
- Creating complex SSIS ETL packages to perform data extraction from Oracle environments and load data into SQL application to be able to consume by end users through reports.
- Designing efficient ETL packages to perform nightly data loads consuming Billing data to perform analytical reporting.
- Worked on Oracle to SQL server migration project re-creating applications in sql server environment.
- Worked in an agile Kanban SDLC project methodology.
- Creating dash visualizations using Power BI consuming billing and enrollment information.
- Created several SSRS reports consuming billing data and providing transactional reports to end users on daily basis using subscriptions.
- Acted as quality analyst to perform QA on extracts created by peer developers and validating data as per requirement documents.
- Creating new documentation on newly created extracts as per standards.
Confidential, Goodlettsville, TN
Sr MS SQL Server BI ETL Developer
Responsibilities:
- Responsible for installations of SQL 2017 suite of products along with setting up the Development environment on windows 2016 server.
- Analyzing existing applications and their data needs for implementing new extracts into Data warehouse.
- Responsible for designing the Fact and Dimension tables in enterprise data warehouse and creating relationships using Snowflake schema model.
- Extensively on extracting the data from Oracle source system and writing complex PL SQL Query to extract the required data elements into SQL Data Warehouse using SSIS tool.
- Designed several extracts using SSIS 2017 which will gather sales information generated from the individual stores for analytical data processing needs.
- Worked on creating a High level ETL architecture for usage across the projects, to be able to process the data with capability to reprocess specific errored data records in consecutive ETL loads.
- Interacting with end users as Business Analyst to gather the data requirements for analytical reporting needs of the sales data generated from all over the stores.
- Working on bug fixes and enhancements to existing ETL extracts.
- Responsible for scheduling and maintaining the ETL jobs using OpCon job scheduler.
- Responsible for Quality Analysis (QA) of data being loaded from Oracle Source to SQL server Data Warehouse for delivering bug proof products.
Confidential, Dallas, TX
MS SQL Server BI Developer
Responsibilities:
- Involved in creating the extracts and interfaces to enterprise data warehouse which is storing the data coming from different hospitals using SQL Server Integration Services (SSIS).
- Created several extracts which downloads the source data from external SFTP/FTP sites and automating the ETL extracts to run on a given daily and weekly schedules.
- Re-architecting and re-engineering existing ETL processes to stabilize daily extracts by analyzing the end to end process flow and identifying the bottlenecks.
- Working on Agile and Waterfall methodology projects right from requirements gathering, creating mapping documents from end users and developing the ETL projects.
- Created several efficient SSIS packages to incrementally load the data into data warehouse application every day in order keep the source and target in sync.
- Successfully reengineered the jobs to reduce manual dependency of loading of existing daily extracts and Created error logging and error email mechanism for effectively capturing error information to quickly identify and rectify the issue in case of ETL job failures.
- Acted as a Business Analyst in gathering the requirements from end user and creating mapping document for creating SSIS ETL Extracts
- Worked on McKesson and Medhost EMR (Electronic Medical Record) system data.
- Working on new enhancement data requests from end users for creating new data feeds and capturing the required data elements to support the SSRS reporting requirements.
- Designed several SSRS Scorecard reports like Emergency Department Score Card, Physician Scorecard reports for Hospital CFO’s and other business users to provide high level understanding of how crucial departments performed on day to day basis.
- Delivering the SSRS reports to end users using SSRS Subscriptions and Data driven subscriptions enabling the Nurses to have all the required data before their day starts.
- Responsible for testing the processed data to make sure the total amounts and Total Payments are matching with the expected results.
- Extensively worked on SSRS Dash Board reports which will show the overall revenue generated for a given day from each hospital and sharing delivering the reports to Hospital Executives.
Confidential
BI ETL Developer
Responsibilities:
- Environment set up in the server which includes installing all the necessary tools in the server.
- Gathering requirements from end users and creating business requirement documents (BRD)
- Extensively involved in performing C# .net code changes for application enhancements and to resolve the time out issues happening with front end application.
- Working on the impact analysis of all the interfaces affected with the migration from SQL 2008 to SQL 2014 are analyzed.
- Worked on creating SQL Stored procedures, views and performing SQL code changes to existing code base to meet the enhancement requests.
- Creating Triggers to maintain database integrity. And as per the new requirements and creating new scalar and table valued Functions.
- Performing property changes, Database configuration changes and configuration setup to the components impacted with the migration.
- Creating the new ETL mapping documents with business analysts.
- Using SQL Server Integration services SSIS 2014 for creating daily data feeds from third party applications to reporting data warehouse by supporting different types of data sources like Flat file, Excel and Oracle SQL server.
- Created multiple SSIS ETL extracts to incrementally load data into Data warehouse using different Blocking and non-blocking transformations like Merge, Lookup, Copy Column, Row Count, Multicast, UNION and UNION All transformations.
- Creating daily jobs using SQL Server Agent and scheduling the ETL jobs to kick off on daily basis to keep the source and target systems in Sync and for providing latest reporting data to end users.
- Acted as scrum master and assigning work across the team members.
- Communicating and coordinating with multiple upstream team (source systems) and downstream (target systems) applications to see all the applications in new servers are up and running.
- Interacting with the Business people in order to get the approval for moving the applications to the production.
- Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT).
- Technical and application training to the new resources.
- Involved in the Internal and external reviewing of the critical documents such as SOX compliance (Sarbanes-Oxley Audit report checking), test case and results documents.
- Creating Deployment documents.
- Involved in the deployment activities.
- Given warranty support for deployed applications.
- Created Data Center Transformation (DCT) checklist document to track the activities.
Confidential
SQL Data Analyst/BI Developer
Responsibilities:
- Taking the client calls to get all the business requirements.
- Worked on the requirement gathering and impact area analysis (Identified around 90+ interfaces impacted)
- Created new data mapping documents according to the requirements.
- Taking the Architecture design review whether our solution approach is not impacting the existing architecture of the interface and if there are any changes in the architecture did all the required java code changes, created new audit reporting, error reporting, email alerts techniques and also ensured new architecture changes are not impacting the existing functionality and still supporting new requirements of the project.
- Worked on creating the Designs like use cases, Sequence diagrams, context diagrams of the projects.
- Pulling and pushing the data to target systems from the source systems based on the requirements of the target system using SSIS ETL tool.
- Created error logging and error email mechanism for effectively capturing error information to quickly identify and rectify the issue in case of any job failures.
- Creating schedules for the Weekly and daily runs of the modules using SQL Server Agent.
- Developing intermediate Business logics for transferring the data from source to targeting systems.
- Writing Shell scripting to transfer the files using different protocols.
- Writing Stored Procedures, SQL queries for pulling and inserting data in to the database target systems.
- Understand Existing applications architecture and understand EAI Application requirements.
- Design middleware solution for GIF (Global Integration Factory).
- Creating system analysis document, Information Design Documents, Systems Requirements Document, Deployment guide, Test cases.
- Creating and testing (Unit Testing, System Testing and UAT) the test cases of the applications developed.
- Capacity/Infrastructure estimation/planning for the existing and new applications.
- Deployment support for production and post-go live support for the EAI interface.
- Client, offshore, onsite handling.
- Architecture and Deployment review scheduling and handling.
- Cutover and back out planning for the applications deployment.
Confidential
SQL BI Developer
Responsibilities:
- Involved in Architecture and Design of interfaces.
- Preparation of interface designs document, efforts estimates, gap analysis, design, Capacity estimates and server sizing.
- Installed SQL Server 2008 suite with multiple instances.
- Created complex SSIS packages using SQL server Integration Services 2008 for loading the Flat File and DBF format data into the database.
- Designed the SSIS packages using SQL Server Integration Services 2008, making the entire process of reloading the data with minimum effort by passing variables to the SSIS package. Scheduling a Job to run for loading the data available at different time intervals in a Year.
- Extensively used SSIS script task with C# .Net coding to extract table contents (Screen Scraping) in the HTML layout from the website.
- Created complex stored procedures for loading the data between different Servers.
- Involved in importing and exporting tables data between different servers using SQL Server Import Export wizard.
- Developed Dynamic SQL query for pivoting a large table contents data into a table fitting the predefined schema by generating multiple lines of SQL query for extracting data from the source tables.
- Created Complex Reports using SQL Server Reporting Services 2008 like cascaded parameterized reports.
- Worked on optimizing the stored procedures for faster population of the reports in the report server.
- Extensively used Merge statement feature introduced in SQL 2008 to perform inserts updates and deletes simultaneously.
- Designed and developed List Reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Charts, Functions and Formulas.
- Created Jobs using SQL Server Agent which will run at regular intervals of time if the given condition is satisfied and then refreshes the database with new data.
- Helped team members in resolving the issues. Pro-actively provided the solutions for the issues we have faced and raised during testing phase. Fix the issues.
- Coordinated with team member and helped them in developing the interfaces and helped them fixing the issues they have faced during their development and testing.
- Validation of Unit test cases and integration test case test results.
- End to end testing of interfaces.
- Conducted the User acceptance testing.
- Conducted Internal Code Review
- Assistance in quality configurations like CM Audit and quality acceptance milestones.
- Supported the Sustain team during deployment of the project
Confidential
Assistant Systems Engineer
Responsibilities:
- As a trainee resource closely worked with Sr developers and learned the best coding techniques and methodologies used in the IT industry.
- Involved in front end UI application design using ASP .net and C# for implementing business rules.
- Unit testing and bug fixing.