SUMMARY:

Solutions oriented,Innovative and result driven Database Consultant with 8 years of experience in the Database/Data Warehouse design, analysis, development and management of Business Intelligence Solutions across diverse industries (Retail, Supply Chain, Auto Insuracne, Finance, Enterprise Compliance, HR).

SKILLS:

Technical Expertise & Area of interest: Enterprise Database Management, Database/Data Warehouse,Design & Development, Performance Tuning, Data Integration, Report Design and Development, Database Administration, Data Quality Analysis, Data governance, Data Steward and Data Custodian, Data management & Policies, Risk Management, Data & ETL Modeler, Analytic and Research, Agile & Scrum development, Big Data & NoSQL.

Management Expertise: Team collobration & managment, Reource management, Agile project management

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Responsibilities:

• Participated in the DB Design, Reports & ETL development & design for a small data management program
• Comprehend Source to target mapping specifications, design, code and testing
• Participated in code reviews of ETL design, SSRS reports & SQL processes
• Performance tuning and optimization of DB designs, Reports
• Lead design and analysis sessions with developers to ensure sound team decision - making, and come up with the best appropriate solutions
• Standardize all design and development processes across the entire data provisioning and process ETL layers
• Provide leadership of an on-shore team and collaborate regularly with a small team of offshore maintenance and support staf
• Participated in production deployment & managed end to end deliverable followed by CIT, UAT & QA cycles
• Strong problem solving & trouble shooting skill, Identified and resolved very complex report & query performance issues
• Demonstrated application DBA skill sets with expertise in index tuning, query performance tuning, SQL installation, Complex query writing, Backup & Restoring databases
• Designed & delivered SSIS packages, SSRS reports, cubes, score cards, Heat map reports & KPI reports
• As Technical lead for enterprise compliance data warehouse portfolio, I have managed ETL team, reporting team and SQL developers, participated in QA & BRD session to provide technical guidances

Environment: SQL Server 2008R2, SSRS, MS Excel 2003/2007, MS Visual Studio 2008, Windows Server 2008, MS Outlook 2010, Team Foundation Server 2010, SQL server 2012, SSDT tools, Sybase PowerDesigner 16.0, Erwin

Confidential, Cherry Hill, NJ

MS BI/SQL Developer/Analyst

Responsibilities:

• Installed and maintained SQL Server 2005/2008/R2 for different environment.
• Maintain day to day file handling, data source development, delta load and keep up to date the data acquisition system.
• Identify new data sources from various data source provided, data validation & profiling expertise
• Build and managed more than 100 data sources requirments for ETL workflow
• Prepare data source requirement, manage source to target mapping data source requirement.
• Planned, Defined and Designed database based on business requirement and provided documentation.
• Gathered data and documented it for future reference and designed data modeling using Visio.
• Hands on experienced on DBA functionality like routine backup, log management, index management, File handling, database maintenance, SQL Agent job setup and management.
• Created SSIS package to load data from Flat file, csv, oracle, Sybase, db2 to SQL Server 2008 database with SSIS ETL/DW tool to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the business requirement and user request.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2005.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Designed and implemented Stored Procedures for automating tasks.
• Responsible for validation data source requirement, use case development, unit testing, sanity testing and validate data against the business requirement.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visio, Microsoft Office, Microsoft Query, Excel 2003/2007, SalesForce, Visual Studio.

Confidential, Parsippany, NJ

Lead BI/SQL Developer

Responsibilities:

• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of constraints and Triggers for Data Consistency, Used Stored Procedures for updating Servers.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into respective supplier’s data warehouse.
• Creating and running SSIS Packages for Importing Data from flat file, xml, CSV, Pipe Delimited and Fixed Length Files with various file formats. Responsible for creating log files for SSIS packages.
• Involved in creating SSIS Packages on basis of Supplier and Retailer specific attributes and automated packages to run daily/weekly basis.
• Worked with Check points in SSIS package, Created break points in order to view the status of data, variables and over all status of SSIS packages.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports, score card and dashboard with drill down and drill through option using SSRS and Microstrategy.
• Create OLAP cubes with SSAS based on multidimensional database with star schema or snow flake schema, Created UDM for cubes in SSAS.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS, Involved in building of OLAP cubes with SSAS and in adding calculations using MDX. deploying the SSIS Packages from development server to production environment to load weekly data through flat file system (handles daily/weekly data)
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Created database Objects like Tables, Stored Procedures, Views, Triggers, functions for this project.
• Providing training to new employee related to Edifice’s Production system and product life cycle, types of products and Supplier chain solution, Retailer solutions and Data warehouse Systems, data marts, system procedures and structures.
• Provides subject matter expertise, training, and/or end-user support for production BI solution

Confidential, Parsippany, NJ

Business Intelligence System Specialist

Responsibilities:

• Responsible for working with project development team, sales and business team to gather requirement and translate functional requirement into high level technical requirements.
• Providing Solution between Supplier/Retailer to maximize their supply chain cycle from start to end.
• Responsible for delivering and developing business intelligence solution that helps supplier and retailer to analyze their data.
• Confidential collects point-of-sale, merchandising, and supply chain data and transforms it into the reports and analyses vendors need to help retailers manage assortment localization, inventory allocation, promotion tactics, markdown strategy, and more.
• Developing reports for the Supplier and retailer to provide strategic solutions, KPI to measure customer’s business, line charts.
• Familiar with supply chain management and Supplier specific attributes, Retailer specific attribute and all matrix related to supply chain industry.
• AS business intelligence specialist I was responsible for analyzing data in large data warehouse, data mart and operation system.
• Responsible for interfacing with Data acquisition team and source system to determine if data for particular week, supplier, and particular reports are available or not.
• Responsible for analyzing, designing and developing business reports and analytics initiatives within business intelligence team.
• Interacting with EDI specialist, removing duplicate from raw data and make it load to the system
• Design and developed ETL packages which loads raw data from different format like text, excel, xml, flat file, CSV with various format into system.
• Providing project level 1 and level 2 solution for the system related projects. Working with Salesforce (CRM) system to manage cases and projects to support the system.
• Responsible for analyzing, designing and developing business reports and analytics initiatives within business intelligence team.
• Supplier Services: Reporting for all retailers, Customized Account management report, decision-ready analysis, UPC/Store-level detail, Various types of Reports
• Retailer Services: data sharing program, reduce cost of reporting, Improve supplier performance, Increase buyer productivity

Environment: MS SQL Server 2008/2005(SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visio, Microstrategy Reporting Suite, Microsoft Office, Microsoft Query, Excel 2003/2007, Sales Force, Visual Studio.

Confidential, NJ

Data Warehouse Analyst

Responsibilities:

• Collecting data from multiple sources including sales, inventory, product, and customer databases to create integrated views that can be used to drive decision making solution.
• Created database objects like tables, view, store procedures, triggers, T-SQL scripts, indexes.
• Creating logical and physical diagram of the databases, prepared Entity relationship diagram and dimensional diagram, familiar with Data warehouse concepts, star schema, snow flake schema.
• Working with several large and complex SQL databases, very large data warehouse.
• Created SSIS packages for various functionality to load the data, automate the ETL structure.
• Developed SSIS packages to clean data from various source with different file format and apply extraction, transformation and loaded to final data-marts.
• Working with OLAP reporting technology, such as cubes, MDX, and data mining techniques
• Developed and designed various reports to provide strategic solutions and decisions, prepared drill down, drill through, matrix reports.
• Designing and building reports and analyses in Excel, SQL Server reporting services, created report with Microsoft SQL Query.
• Helping to test, benchmark and optimize existing database queries and procedures
• Consulting with internal customers (e.g., Marketing, Logistics, Customer Service) to develop analyses that lead to actionable insights that accelerate profitable growth

Environment: MS SQL Server 2008/2005(SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visio, Microstrategy Reporting Suite, Microsoft Office, Microsoft Query, Excel 2003/2007, SalesForce, Visual Studio.

Confidential

Database Analyst

Responsibilities:

• Involved in migration from SQL Server 2000 to SQL Server 2005.
• Migrated DTS packages from SQL Server 2000 to SSIS using SSIS task.
• Created DTS packages for data extraction from multiple data source to SQL Server and scheduled them using SQL Server Agent.
• Analyzed the requirement and Generated various Report models on Views (due to security issues) and deployed them on the production reporting server and generated various Report models and ad-hoc reports.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Developed daily, weekly, monthly reports and published them on the company’s intranet.
• Wrote complex stored procedures, triggers, cursors, tables, constraints, views and other SQL joins and statements for applications.
• Identified the data source and defined them to build the data source views.
• Created Queries for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts using SQL Server Reporting Services.
• Generated Reports using global variables, expressions and functions for the reports.
• Created SSIS package and scheduled them using SQL Server Agent.
• Implemented transformation using SSIS to extract data from flat file into SQL Server.
• Designed and implemented SSIS package to extract data from multiple source to OLTP.
• Formed database objects like tables, views, indexes and complex queries in T-SQL.
• Maintained database performance by applying tuning procedures like normalization, indexing, system monitoring.
• Wrote complex T-SQL queries and also checked performance of the query using SQL Profiler.
• Created efficient and critical drill-down reports according to business requirements.
• Created and automated the regular jobs and alerts using SQL Server Agent.
• Reviewed Business Requirements Documents and the Technical Specifications.
• Reviewed Software Requirements Specifications and Software Design Specifications.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, Constraints and Roles.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS Access, Windows 2000 Server, SSRS, SSIS, HTML

Confidential

System Analyst

Responsibilities:

• Responsible for analyzing, designing and developing business reports and analytics initiatives within business intelligence team.
• Interact with business user, gather requirement, understand the system specification and technical specification details related to business intelligence platform and implemented proper solution.
• Developed Ad-Hoc Reports, list reports, drill down, drill through, Matrix reports, summary reports and trend analysis report with the help of Microsoft SQL Server and Reporting Services.
• Created logical design and physical design of data base with Visio.
• Developed Entity Relationship diagram and Dimensional modeling for given system with SQL Server Diagram and Visio.
• Strong expertise in Database system (OLTP) and Data Warehouse System (OLAP) systems.
• Created different database objects like tables, views, store procedure, triggers, Index, Functions with SQL Server.
• Developed and run reports with SQL Server and Microstrategy for user supports and business requirement and performed various analyses like gap analysis, trend analysis, high profile, low profile, key performance indicator of the business, variance analysis.
• Worked on call 24/7 support for as system analyst to support the system and fulfill customer requirement and issues at night and in the weekend.

Environment: Microsoft SQL Server, Microsoft SQL Server Reporting Services, Crystal Report, Microstrategy, Visio, Microsoft Outlook, Windows Server 2003.