SUMMARY

• Microsoft BI Engineer with Over 10+ years of experience in implementing Data warehousing solutions, Data Migrations with 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 with 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 the performance of queries with 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 with the Business users, Application Users and Stake Holders - all belonging to different departments and divisions to ensure the smooth running of the applications.
• Having good experience in creating SSIS framework like Error handling, memory management, Error logging, and code reusability along with 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 the development phase.
• Involved in all phases of data warehouse development including prototyping, data modelling, analysis, design, development, testing and documentation.
• Involved in creating the snowflake schema and structural designs to meet the existing and forthcoming business plan of action.
• Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards and techniques.
• Planned and completed delegated tasks within agreed timeline with lofty standards, identified problems and collaborated with 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 the 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 with management and end-users to create and evaluate business requirements to support the 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 the development and testing of database scripts and back-end processes to support system.
• Integration and ETL to facilitate the creation and population of staging databases, operational data stores (ODS), data marts and other data integration solutions.
• Implement the user access controls and data security measures where appropriate.
• Create and maintain documentation of processes, databases, applications and procedures.
• Support interfaces with users and third party vendors.
• Support the design, planning, implementation, administration and maintenance of the database and ETL platform.
• Mentor and support the training of peers and business users in the proper user of the database and end-user software tools.
• Maintain the 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 the data from heterogeneous source into QNXT environment.
• Creating and managing SSRS reports using SSDT 2015 R2 for different business areas.
• Automated all the 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 the 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 the Jenkins, TeamCity and Octopus to build and deploy the SSIS application on test environments and to resolve the 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 the 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 with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Developed confidential proprietary analytical tools and reports with 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 the 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 the 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 with complete audit trails to help achieve HIPAA compliance.
• Worked in Design, Coding and Peer Review of the projects.
• Created Reports for business users to visualize the 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 the requirements and analysis, involved screen and database designing.
• Involved in the creating interactive UI and complex databases design and coding using Classic ASP.
• Provided production support during warranty period for the application maintenance and troubleshooting issues.

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