SUMMARY

• 10+ years of experience in Data Modeling, Dimension Database Design, Programming, Development and Implementation of Client - Server Applications and Database systems using MSSQL 2019/2017/2016/2012/2008/2007/2005 for both OLTP (Batch Processing, Online Processing) and Kimball Methodology.
• Experience in various business domains like Oil-Energy,Retail & financial serviceswith high Operational/transactional and multi-server production environments.
• Strong T-SQL experience in creating database objects like tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes.
• Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, Star schema for OLTP/OLAP systems.
• Involved in heavy data migration/ETL activities using BCP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2000/2005/2008R2/2012/2016/2017/2019).
• Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2008 advanced features in Control flow, data flow, Error Handling and event handling.
• Expert in IBM Web Sphere Data Stage 8x/7x/6x ETL tools & Documentation.
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Real-time experience in modify SSIS package and create SSIS package by using different sources like XML, SSAS cube, web-service.
• Work on Electronic Data record tool for retail and oil energy firm me.e. EMR, ERP, Right Angle, and CompuLink.
• Strong noledge in Performance Point Server 2005/2007/2010 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts, and SSRS Reports.
• Extensive experience in SSRS/PowerBI (Reporting services) and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Form, OLAP, and Sub reports, and formatting them.
• Created user stories, backlog sprints, burndown charts by using JIRA& TFS Agile Project development environment.
• Develop & Design reports using SSAS & SSRS on SQL Server (2000/2005/2012/2016/2017/2019), good experience and understanding of SSAS, OLAP cube and understand Architecture for various business model.
• Worked on SQL BI solution integration with Microsoft SharePoint Server (MOSS); expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Involved in Security Administration, Managing schemas (2005), creating Credentials, creation of users, configuring Permissions and assigning roles to users.
• Experience in develop/maintain web applications using .NET Framework, .NET Core, ReactJS, JavaScript and Web Services Involved in 24/7 production support and experienced in testing environment.

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Senior Data Analyst/BI Developer

Responsibilities:

• Working with Team to understand Banking Enterprise Data Solutions.
• Work with Business team to understand requirement and transfer it into technical requirement, convert into technical documentation and work on Data modelling for new Datamart/Dataset for Project.
• Understand Banking, Mortgage Insurance, and COVID-19 requirement and work on Data Analysis and generate SSAS Cube from this data & create SSRS Reports for business team.
• Develop SQL Table, Stored Procedures& SSIS Package using defined source and SQL/NoSQL Destination.
• Design and Develop Complex SSIS Package for Flat File, Excel File source in zipped folder also archive files after Dataload process.
• Include Error Handing and Logging Feature in ETL Process.
• Monitor Production ETL Jobs and Validated all Data landed correctly and work on Production support.
• Discuss with users on report requirement and after delivered reports follow up directly with business team on any post release changes into reports.
• Optimize Reports if needed also Manage Scheduling daily SSRS reports.
• Work on SQL Agent job creation and AF Configuration in Agent jobs for Dev/Test/Prod Server.
• Document each process of development & submit Documentation for Production Release.
• Handle SSRS server configuration along with deploy reports in dev/test/prod environment with latest changes.
• Optimize existing reports with apply changes in SSIS Packages &SSRS adhoc Queries.

Environment: Microsoft SQL Server 2019, VS 2017, AzureDevOps, SSIS-SSRS, MS Visio Modeling Tool, SQL Server Agent, TFS-GIT, Jira.

Confidential, Woodlands TX

Senior Database Engineer

Responsibilities:

• Designoil-energy business data mart as per requirement and created database with tables, stored procedures, functions, and indexes, triggers.
• Created business process diagrams to describe the various data flow using MS Visio.
• Worked on Data Modelling for various projects and suggest changes into reference integrity for some tables.
• Work on SSRS/PowerBI reports as per business requirement include operational/functional reports.
• Discuss with users on report requirement and after delivered reports follow up directly with business in case need any changes into reports.
• Understand Business data and Define snowflake schema include facts & dimensions for this project database.
• Understands business requirement with MobileFrame application and works on technical documents for apps program with SQL codes, developed various ETL Stored Procedure, Create, and maintain SQL Jobs in SQL Server 2016.
• Work on different SSRS chart Reports for web portal & mobile platform using Cube and SQL queries.
• Work on TFS server 2015 for all daily task planning, using source control for code versioning, test cases and release change sets.
• Performed requirement analysis by gathering both functional and nonfunctional requirements based on interactions with the business process owners and represented them in the requirements traceability matrix (RTM).
• Work on production support work and day-to-day DataMart Structure changes with adding new index, Trigger, LOCK hints for Stored Procedure ad hoc queries.
• Project required to deliver all business solutions in CICD model as clients required continuous receive changes for their Applications for daily users.
• Handle SSRS server configuration along with deploy reports in dev/test/prod environment with latest changes.
• Work with Software QA team to develop Test plans and suggest some changes based on my expertise.
• Managing SSIS/SSRS Packages along with configure with enterprise SMTP Servers for Daily notification on any errors.
• Work on Development/support work for frontend/backend web applications in MobileFrame, UI Support work with using .NET Core, React JavaScript.

Environment: Microsoft SQL Server 2016, VS 2017, SSIS-SSRS, MobileFrame, MS Visio Modeling Tool, SQL Server Agent, SQL Sentry, Performance Monitor, React JavaScript, Redux, .Net Framework, AzureDevOps, Team Foundation Server - 2015.

Confidential, Houston TX

Senior BI Developer/Database Engineer

Responsibilities:

• Designs business data mart as per requirement and created database with tables, stored procedures, functions, and indexes.
• Provides production support for existing web application debug and backend ETL work for applications.
• Understands business requirement, works on technical documents for ETL process flow for project, and developed various SSIS package in VS 2012.
• Work on SQL BI solution integration with Microsoft SharePoint Server (MOSS).
• Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Work on POC for latest technology for Enable Oracle CDC from SQL Server 2012.
• Work on BI reports with SAP - Business Objects (Universe) reporting platform and SSRS.
• Works as Lead BI Developer for team also has database admin duties as per team demand.
• Document the project work in Interface and for all process.
• Manage SSRS/PowerBI report solution for downstream/midstream datasets.
• Data Extraction from FTP/SFTP servers and load into SQL Server for reporting purpose.
• Works on POC for company major ETL Design and Develop & Implement new Incremental Data Process.
• Work on production support work and day-to-day DataMart Structure changes or handle new requirement and migration plans for project.

Environment: Microsoft SQL Server 2012/2008, VS 2016/2012, SSIS-SSRS, Oracle PL/SQL, MS Visio Modeling Tool, SQL Server Agent, Microsoft Excel, Performance Monitor, Team Foundation Server - 2013,SAP Business Objects, and SharePoint

Confidential, Houston TX

Senior BI Developer/Data Analyst

Responsibilities:

• Created various database objects such as tables, indexes and views based on the requirement.
• Provided production support like efficient stored procedure, function, index, and improve performance of existing data warehouse.
• Understand business requirement, worked on POC (Proof of Concept), and developed ETL process.
• Provided support for daily ETL jobs and BI and SQL related issue.
• Worked on SSIS package with Oracle, FTP server, Flat File different sources.
• Created Templates for Complex Stored Procedure and SSIS packages for offshore Team.
• Improved performance for any existing ETL Process related T-SQL or BI for any given project.
• Understood Business Requirement and Analysis on Production Data and resolved Existing Issue.
• Worked on existing Database Object in SQL server 2008R2/2012 and performance tuning for Stored Procedures and other Database Objects.
• Worked on BI reports for Business team and functional team with SSRS 2012.
• Developed reports on SSAS & SSRS on SQL Server (2010/2012).
• Good Experience and understanding of SSAS, OLAP cube and Architecture.
• Led Offshore Team for Production support and integration services.
• Worked on POC and ETL model for business solutions and company new application.
• Completed back-end work for Enterprise Application and Give Support work.
• Handled technical documentation for all SQL/BI object includes stored procedure, SSIS, and SSRS Report.

Environment: Microsoft SQL Server 2012, SSIS 2012/2008, Oracle PL/SQL, ERD Erwin Data Modeling Tool, Microsoft Visio, SQL Server Agent, Microsoft Excel, Performance Monitor, TOAD, Team Foundation Server - 2013, Vertica, Poly Analyst, SharePoint, and SSRS Reporting Tool

Confidential, Austin TX

Senior SQL/BI Developer (SSAS/SSIS/SSRS)

Responsibilities:

• Developed Complex ETL SSIS Package & stored procedures within different source environment.
• Created Complex SQL stored procedure, triggers, index on table to improve existing database table’s performance.
• Performed data modeling from Microsoft Visio and Erwin tool to create and maintain ERD Diagram for database with star and snowflake schema.
• Understood business requirement and coordinate with users for daily and weekly business report from SQL statement and ETL Package.
• Worked on FTP, SFTP site with creates SSIS Package for end client integration support.
• Worked on Oracle Application retail module and Created Logic & program for users to create various sales audit report, dynamic drill down reports, dashboard reports.
• Led BI Team and Create Template ETL SSIS Process for staging environment between Oracle and SQL source for integration support.
• Created detailed requirements specification document for software enhancement/change requests.
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans.
• Created and maintained business process diagrams to describe the various data flow using ER Diagram &MS Visio.
• Gained hands-on experience on database application development, installing, and configuring Hardware for entire team.
• Maintained technical documentation related to SQL database and all ETL process.

Environment: MS SQL Server 2012/2008R2, Oracle PL/SQL, ERD Diagram Tool, Microsoft Visio, SSIS 2010/2007, SQL Server Agent, SQL Profiler, Performance Monitor, Microsoft Excel, Team Foundation Server, SharePoint, and Cognos Reporting

Confidential, Atlanta, GA

SQL Server/Database Architect/SSAS/SSRS

Responsibilities:

• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Developed SQL code to migrate data from multiple sources.
• Supported business users for given requirements and developed the reports accordingly and ETL operations in PL/SQL.
• Developed reports on SSAS and SSRS on SQL Server (2007), good experience and understanding of SSAS, OLAP cube, and Architecture.
• Created SSIS packages to clean and load data-to-data warehouse different objects.
• SSIS packages to transfer data between OLTP and OLAP database using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task to load underlying data in to the tables from Text files.
• Developed SSAS cubes and gained experience in developing and extending OLAP Cubes, Dimensions, and data source view.
• Deployed the dashboard to SharePoint 2010.
• Used various report items like tables, sub report and charts to develop the reports in SSRS and Cognos environment.
• Deployed and scheduled SSIS package for production support and requirement from client side.

Environment: Microsoft SQL Server 2012/2008R2, PL/SQL, ERD Diagram Tool, SSAS 2012/2008R2/2007, SSRS 2012/2008R2, T-SQL Procedures, SQL Server Agent, SQL Profiler, ASP.NET, Performance Monitor, Microsoft Excel, Team Foundation Server, and SharePoint

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Gathered requirements from client and understood current database and system environment and tan integrated it with business logic and made documentation on it.
• Based on documentation, started work on generating different data models for the data warehouse and worked on data mapping and profiling and created hierarchy as per business requirements.
• Started working on specification and transformation while working to create new structure of DW and other objects like ETL store procedure, required sys tables, look-up tables, and linked servers to fetch data from different servers.
• Gained hands-on experience to create complex store procedure and ETL SSIS packages to load records into DW tables, also needed to maintain referential integrity between DW tables.
• Generated SSIS package for ETL process and to develop source to Client data mappings using SSIS various tasks, such as execute SQL task, data flow task, execute package task, etc.
• Gained experience in creating index and refreshing indexes, non-clustered index as per required schedule on a weekly or monthly basis.
• Worked on database snapshot also worked on CDC database and used CDC records to get incremental records for DW tables, had responsibilities to daily nightly load process; handled job scheduling and daily email notification via SQL Server agent.
• Created some ad-hoc reports, drill-down, parameterize, and drill-through reports from SQL Server Reporting Service 2008R2 for end users and clients.
• Gained documentation skills and worked on multiple tasks to maintain project flow.

Environment: MS SQL Server 2007/2008R2, T-SQL Procedures, SQL Server Agent, Performance Monitor, BIDS 2008R2, Microsoft Excel, Team Foundation Server, SharePoint, Irving Data Modeling Tool, and Microsoft Visio 2007

Confidential, Kansas City, MO

Data Analyst/Data Stage

Responsibilities:

• Responsible for migrating data from staging area to enterprise-wide data warehouse to store reliable data for decision support systems using DataStage.
• Transformed data in ODS databases and loaded it into the Enterprise data warehouse using SQL Server Integration Services.
• Used several stages like transformer, sequential flat file, aggregator, remove duplicates, merge, sort, and lookup during the development process of the DataStage jobs.
• Worked to design dimension model for business process during project.
• Set-up SQL Server Agent Jobs for periodic back-ups with back-up devices, database maintenance plans, and recovery.
• Gathered and analyzed the requirements from both external and internal users.
• Created reports using SQL Server Reporting Services based on the requirements.
• Responsible for transferring the data using SSIS packages.
• Involved in creating web portal for External clients using Microsoft SharePoint 2010.
• Monitored the overall performance of the database to recommend and initiate actions to improve and optimize performance.
• Handled SSIS package deployment to production server as well as job scheduling for packages on a daily basis.
• Generated Cubes using SQL Analysis Services (SSAS) and gained experience in developing and extending OLAP cubes, dimensions, and data source view.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Created complex SSIS package from POS/XML source.
• Participated in review meetings with the project manager to ensure that the development of projects meet business and system requirements.
• Documented the project work in interface and for all process.

Environment: Microsoft SQL Server 2008/2008R2, .NET Framework, AS400, Data Stage 8.0/7.5.1 (Ascential, IBM Web Sphere), Management Studio, SSIS, SQL Profiler, MS Excel (Documentation), and Windows XP Professional

SLK SOFTWAR

Microsoft SQL Server Developer/SSAS

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2000.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements (me.e.: using Indexes& tweak queries) and Stored Procedures.
• Maintained disaster recovery and database maintenance plan.
• Worked on replication of data (transactional method used).
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Performed job scheduling and alerts.
• Designed and implemented user log in and security.
• Resolved any deadlocks issues with the databases/servers on a real-time basis.
• Gained in-depth working noledge of ODBC.
• Created many complex stored procedures and user-defined functions.

Environment: MS SQL Server 7, SQL Server 2005/2000, T-SQL, and Windows NT 4/2003/2000

TECHNICAL SKILLS

Expert: SQL Server 2019/2017/2016/2012/2008/2007/2005

Expert: MSBI 2019/2017/2016/2012/2010/2007/2005(SSIS/SSRS/SSAS)

Oracle: PL/SQL 10g/11g/12g, Cognos BI - ETL Support, Data Stage 8x/7x

Analytics Tool: AzureDevOps,Vertica, SAP Business Objects, Universe, and Poly Analyst Server,Jira, Team Foundation Server 2015/2013/2010/2008, SharePoint.

CICD, Project Methodology: Agile, Waterfall, Scrum

Intermediate Experience: JavaScript, Developer 2000, ERD Diagram tool Erwin, UNIX, Windows, XML, and VBScript, Kimball Methodology.