SUMMARY

• Microsoft BI Engineer wif Over 10+ years of experience in implementing Data warehousing solutions, Data Migrations wif Data Stewardship.
• Design, develop and implement Hybrid solutions for small to large - scale enterprise data warehouse using ETL tools like Microsoft SQL Server Integration Services (SSIS) and reporting tools like MS SSRS and Power BI.
• Integrated complex HealthCare systems into Single warehouse and report data to top level management to daily users by Configuring Row Level Security RLS on data sets that are using Direct Query.
• Expertise in Data Analysis, Development, Testing, Maintenance and Implementation of database solutions as MSBI Developer wif exceptional skills in design using Microsoft Business Intelligence Suite (SSIS, SSRS, SSAS) and Power BI Proficient in database design, T-SQL, Complex Queries, Stored Procedures.
• Have developed dynamic Reusable-Procedures, Packages, Functions, Triggers, Cursors, Views and Performance tuning.
• Optimized teh performance of queries wif modification in T-SQL queries, normalized tables, established joins and created indexes, column store index wherever necessary.
• Having good experience in CICD version control tool like Azure DevOps, GitHub, TFS, Clear Care and VSS for Code Management and deployment into different environment like DEV, QA and PROD.
• Worked extensively in both Agile & Waterfall methodologies.
• Having experience in regular interaction wif teh Business users, Application Users and Stake Holders - all belonging to different departments and divisions to ensure teh smooth running of teh applications.
• Having good experience in creating SSIS framework like Error handling, memory management, Error logging, and code reusability along wif Precedence Constraints, Break Points, Check Points, Logging.

TECHNICAL SKILLS

Primary Skills: Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI and Crystal Report.

Secondary Skills: Azure Data Factory, Azure Databricks

Databases: SQL Server 2014, 2008, 2005.

ETL Tools: SQL Server Integration Services (SSIS), SSDT 2015.

Scripting Language: Java Script, C# and VB script.

Reporting and Dashboard Tool: SSRS, Power BI and Crystal Report XI.

Source Control Tool: Azure DevOps, Visual Source Safe, Team foundation Server, GitHub

Issue Tracker: JIRA

Deployment Tools: TeamCity, Octopus

PROFESSIONAL EXPERIENCE

Senior Database Developer

Confidential, Princeton, NJ

Responsibilities:

• Participated in business and client meetings to collect business requirements, documented functional & non-functional specifications and prepared system requirements specification document.
• Prepared Use Cases, Functional Flow charts, Data Flow diagrams, and Entity Relationship diagrams to include in SRS which are referred during teh development phase.
• Involved in all phases of data warehouse development including prototyping, data modelling, analysis, design, development, testing and documentation.
• Involved in creating teh snowflake schema and structural designs to meet teh existing and forthcoming business plan of action.
• Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.
• Familiarize teh team wif teh customer needs, specifications, design targets, teh development process, design standards and techniques.
• Planned and completed delegated tasks wifin agreed timeline wif lofty standards, identified problems and collaborated wif team to propose solutions in an effort to solve them.
• Used agile SDLC approach to complete and track tasks on time.
• Responsible for creating database objects like table, constraints, Indexes (clustered and non-clustered), views, stored procedures, triggers and functions using T-SQL to store and maintain data efficiently.
• Involved in writing teh database functional specifications and technical design documents for SSIS packages and reports.

Environment: PL/SQL, Java, Shell Scripting, Crystal Reports, AUTOSYS, SQL Server, Toad, Eclipse, LINUX and Windows.

Senior Database Developer

Confidential, Phoenix, AZ

Responsibilities:

• Actively involved in agile methodology (Kanban) and played as team member role.
• Work closely wif management and end-users to create and evaluate business requirements to support teh delivery of effective data solutions.
• Design, develop, optimize, maintain and support ETL processes using stored procedures, SQL Scripts and data integration tools such as SSIS.
• Create technical designs and functional specifications for back-end and front-end information systems.
• Participate in teh development and testing of database scripts and back-end processes to support system.
• Integration and ETL to facilitate teh creation and population of staging databases, operational data stores (ODS), data marts and other data integration solutions.
• Implement teh user access controls and data security measures where appropriate.
• Create and maintain documentation of processes, databases, applications and procedures.
• Support interfaces wif users and third party vendors.
• Support teh design, planning, implementation, administration and maintenance of teh database and ETL platform.
• Mentor and support teh training of peers and business users in teh proper user of teh database and end-user software tools.
• Maintain teh ETL process jobs and respond to critical data load issues during off hours.

Environment: C#.Net, TFS, MS SQL Server, SSMS, SSIS, SSRS, JIRA, Confluence, Azure SQL Server.

Senior Application Developer

Confidential, Phoenix, AZ

Responsibilities:

• Actively involved in agile methodology (DevOps) and played as lead role.
• Creating and Managing SSIS solution using SSDT 2015 R2 to load teh data from heterogeneous source into QNXT environment.
• Creating and managing SSRS reports using SSDT 2015 R2 for different business areas.
• Automated all teh ETL solution using SQL agents and created automatic notification for management purpose.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as required.
• Created Jobs Performance report that queries system tables to track teh duration of each job and weekly-average duration using SSRS.
• Created complex dynamic store procedures, functions, and all other DB objects using T-SQL.
• Creating and managing Power BI visualizations from Azure SQL database.
• Import vendor and state files into ancillary databases for QNXT process.
• SME in QNXT Member enrollment process.
• Using teh Jenkins, TeamCity and Octopus to build and deploy teh SSIS application on test environments and to resolve teh testing and production issues.
• Using GIT Hub/TFS for version control system.
• Using JIRA to defect tracking and test case management.
• Using Service Now to raise ticket for teh production deployments.

Environment: C#.Net, TFS, SQL Server, Octopus, Team City, SOAP, GitHub, JIRA, SonarCube, Jenkins, MS Test, EDMX Framework.

BI Project Lead

Confidential, North Bethesda, MD

Responsibilities:

• Extracted data from various sources like SQL Server 2008,.CSV, Excel and Text file from share folder to Stage Database.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process.
• Assist in migration of MS Access Databases 2007 to SQL Server 2008 by using Import wizard and SSIS Packages in SQL Server.
• Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline teh proposed solution.
• Developed confidential proprietary analytical tools and reports wif Confidential Excel, and Power Pivot and Power Point.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Conditional Split, Look up, Sort, Data flow task.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled teh Reports in Report Manager
• Created Drill Down Reports, Drill Through Report by Region.

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, T-SQL, Windows 7, MS Word, MS Excel, C#, Visio, SQL Profiler.

Associate Software Engineer

Confidential, Tucson, AZ

Responsibilities:

• As a developer using classic ASP, Java and Scripts (Java Scripts, VB Script and HTML) to develop teh front-end.
• Worked on developing middle tier components using VB and Cache as backend.
• Support for efficient image transport and tracking Comprehensive Protected Health Information (PHI) security wif complete audit trails to help achieve HIPAA compliance.
• Worked in Design, Coding and Peer Review of teh projects.
• Created Reports for business users to visualize teh data using Crystal Report.

Environment: Visual Basic 6.0, Classic ASP, MUMPS, Cache Object Script and Crystal Report 10.0

Web Developer

Confidential

Responsibilities:

• As a web developer to gather teh requirements and analysis, involved screen and database designing.
• Involved in teh creating interactive UI and complex databases design and coding using Classic ASP.
• Provided production support during warranty period for teh application maintenance and troubleshooting issues.

Environment: Classic ASP, Java Script, VB Script, HTML & SQL Server 2000