SUMMARY

• Over 5 years of working experience as a Data Analyst/Business Intelligence (BI) with high proficiency in requirement gathering and data validation and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Experience in Business Intelligence (BI) with a focus on Analytical tools for all kinds of Enterprise Reporting Solutions using SSRS.
• Proficient in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive experience in implementing ETL methodologies, Data Profiling, Data Migrations and Data Conversions.
• Skilled in visualizing, manipulating and analyzing large datasets and also has ability of designing and developing effective reports.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as SSIS.
• Proficient in requirement analysis and system design.
• Extensive experience in creating data scope and requirements. Strong expertise in understanding various data sources.
• Experience working with data analysis tools for data lineage, metadata, and data profiling.
• Extensive experience in the development of Reports using SQL Server 2008 R2/2012 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports. Proficient in Extract, Transform and Load (ETL) process using SQL Server Integration Services (SSIS).
• Strong experience in automation of SSIS packages by scheduling jobs, creating and monitoring alerts
• Experienced in debugging and troubleshooting SSIS packages using breakpoints, checkpoints, error handlers, event handlers, etc.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Expert in monitoring SQL Server Performance, troubleshooting using SQL Profiler and Maintenance plan.
• Experience on Data Model design, Data Extraction, Transformations and Loading (ETL), Mappings & Workflows, Customized Analytics Reports.
• Involved in configuring and using master data services to maintain data integrity in data warehouse.
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor.
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Good team player, strong analytical, written, communication and interpersonal skills
• Have proven track record working with various environments and a valuable ability to quickly pick up new technologies and become an asset to the company in a minimal amount of time.

TECHNICAL SKILLS

RDBMS: SQL Server 2008 R2/2012/2014, Oracle, MS Access, MySql, Teradata, Excel

SQL Server/MSBI Tools: SQL Server Management Studio, DTS, SSIS, SSRS, Power View, Power Pivot, Profiler, BIDS

Languages: T-SQL, UNIX Shell scripts

Version Control Tools: MS Visual Source Safe (VSS), Microsoft team foundation server (TFS), GIT

Operating Systems: Windows, Linux/UNIX

Other Tools: Microsoft Visio, Toad, MS Office, SQL Plus, Tableau

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Analyst

Responsibilities:

• Met with business users, gathered business requirements and prepared the documentation for requirement analysis.
• Provided training to the business users on how to use new data warehouse, browsing cubes from Excel and assisted them in rewriting their existing queries to point to the new warehouse.
• Created centralized data warehouse and developed de-normalized structures based on the requirements and to improve the query performance for end users.
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Extensively used both Star Schema and Snow flake schema methodologies in building and designing the logical data model.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Wrote SQL Queries to analyze and process large data set, and optimize/tune the execution overhead.
• Developed ETL and SQL scripts to enable weekly processing of 2-4 GB data sets into data warehouse.
• Optimized ETL and SQL performance to provide quickest response time possible
• Worked as Data Analyst analyzing complex data patterns, building relationship among Database tables and generating Reports.
• Testing ETL flows, data and Reports based on various technical and business requirements
• Did debugging using break points and data viewers and performance tuning of ETL data flows.
• Created various SSIS packages to populate the data from flat files, Excel and Access into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction-based data).
• Created and configured SSIS package configurations using sql server table and environment variables and loaded data from XML, Flat files and SQL Server incrementally.
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2014 packages.
• Developed various types of reports drill down, drill through, matrix and sub reports using SSRS 2014.
• Created multiple dashboards with calculations and KPIs using Tableau and deployed them in tableau server
• Used team foundation server for version controlling of all BI projects.

Environment: SQL Server 2014, SSIS, SSRS, MS Visio, MS Office 2013, Outlook, Windows Server 2012, Tableau, Windows 8.

Confidential

Data Analyst/MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project
• Worked on defining data source and building data source views and recognizing fact and dimension tables.
• Involved in data mapping specifications to execute detailed system test plans.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).
• Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS.
• Developed strategies and loading techniques for better loading and faster query performance.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling batch jobs.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Generated the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Used the Data Warehousing Life Cycle to identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Created package deployment utility and deployed packages into various environments. Involved in unit testing, SIT, UAT and data validations.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server Reporting Services (SSRS).
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Worked in agile methodology, participated in daily scrum meetings.

Environment: SQL Server 2012, SSIS, SSRS, Share point, Oracle, MS Office 2007, MS Access, ER Win, ADO .Net, Windows Server 200 8 .

Confidential

Jr. Data Analyst

Responsibilities:

• Identified and designed business entities, attributes and relationships between the entities to develop a logical model and later translated the model into physical model
• Involved in complete Software development cycle (SDLC) - Requirement Analysis, Conceptual Design and Detailed design, Development, System and User Acceptance Testing (UAT)
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Carried out various mathematical operations for calculation purpose using Python libraries NumPy, SciPy, Pandas. Responsible for gathering business requirements to build the Enterprise Data Warehouse
• Worked with architects, assisting in the development of current and target state enterprise level data architectures. Performed data analysis and data profiling using Complex SQL on various sources systems including Tera data, MySQL Server
• Participated in writing data mapping documents and performing gap analysis to verify the compatibility of existing systems with new business requirements
• Developed normalized Logical and Physical database models for designing an OLTP application
• Hands on Experience in creating Pivot tables, Graphs in MS Excel and use it for better understanding of the data and give valuable insights
• Analyzed business information to identify process improvements and made recommendations to modify existing applications to correct errors, upgrade interfaces and query optimization
• Developed reporting structure, use case diagrams, project concepts, story boarding and presented data findings for non-technical people
• Experience in using SQL Server Management Studio for writing complex SQL queries and retrieving the required for developing reports and dashboards
• Optimized the data environment in order to efficiently access Data Marts and implemented efficient data extraction routines for the delivery of data
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments with excellent communication skills, strong teambuilding and conflict management skills
• Created Daily, Weekly, monthly reports related by using Teradata, Hadoop/HIVE, MS Excel, and UNIX

Environment: SQL, SSMS (SQL Server Management Studio), EDW, Python, SQL Server, Tableau, Teradata, Hadoop, Hive, MS Excel