SUMMARY

• About 8+ years of experience as a Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Proficient in gathering and analyzing teh Business Requirements wif experience in documenting System Requirement Specifications (SRS) and Functional Requirement Specifications (FRS).
• Responsible for participating in business analysis efforts on business projects having a high degree of technical sophistication. Assisted and mentored Junior BA's in teh project.
• Knowledge for Development, Implementation and Maintenance of Business Intelligence tools and applications.
• Knowledge of designing and creating various analytical reports and Dashboards.
• Expertise in reports, POCs and dashboards using various tools like Tableau, MSTR and Microsoft Excel.
• Strong understanding of data warehousing concepts, OLTP and OLAPdata models.
• Excellent Software Development Life Cycle (SDLC) wif good working noledge of testing methodologies, disciplines, tasks, resources and scheduling
• Excellent noledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Exploratory data analysis using Python libraries such as pandas, NumPymatplotlib, csv, scikit - learn, etc.
• Ability to collaborate wif peers in both, business, and technical areas, to deliver optimal business process solutions, in line wif corporate priorities.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Knowledge of writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, MS Access, Flat files into a staging area. in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power center, IDQ.
• Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: My SQL, Oracle10g, OMWB tool.
• Created reports for teh users using Tableau by connecting to multiple data sources like Flat Files, MS Excel, CSV files, SQL Server, and Oracle.
• Expert in writing SQL queries and optimizing teh queries in Oracle, SQLServer2008, Teradata and Microsoft Power BI.
• Experienced in Qlik View Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads
• Skilled in Data ware housingtools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation.
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing teh issues.
• Exposed to all phases of software development life cycle SDLC including in-depth noledge of Agilemethodology, EnterpriseReportingLifeCycle, SQL ServerMigrations, Changecontrolrules, problemmanagement and escalationprocedures.
• Experience in writing T-SQL, working on Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complexStored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.

TECHNICAL SKILLS

Programming Languages: C, and C++, Python,R, SQL.

Scripting Languages: MS-DOS, Bash, Korn.

Analytics and BI: R, Python, Tableau, Power BI, Advanced MS Excel, Google Analytics

ETL tools: Informatica Power center, SSIS, AB Initio

DataModeling: Sybase Power Designer / IBM Data Architect

Application/Web Servers: JBoss, Glassfish 2.1, WebLogic, Web Sphere, Apache Tomcat Server.

MS-Office Package: Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project).

Databases: Microsoft SQL Server 2014/2012/2008 R2/2008, MySQL, Oracle, DB2, Teradata, MS Access.

ETL Tools / Tracking tool: Informatica, SSIS, SSAS, SSRS / JIRA.

Database Development: T-SQL and PL/SQL, Microsoft Hyper-V Servers

Databases: Teradata R12 R13 R14.10, MS SQL Server, DB2, Netezza

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, CA

Responsibilities:

• Identify, analyze and interpret trends or patterns in complex data sets in MS Excel using Pivot tables.
• Work closely wif management to prioritize business and information needs.
• Derived streaming data insights and stories that drive business decision and usability improvement of teh streaming app from all aspects of teh streamer experience including search, content, clicks, and patterns of behavior.
• Performed hotspot mapping of disease outbreaks during epidemics of H1N1 Influenza and Dengue
• 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 teh DDL using forward engineering Worked in merging and complete compare of Physical models.
• Used teh Data Warehousing Lifecycle to identify data elements from teh source systems, performed data analysis to come up wif data cleansing and integration rules for teh ETL process.
• Leveraging data using BI tools Tableau for Data visualization and storytelling.
• Profile raw data sets across platforms and develop KPI/dashboard to measure product performance.
• Collaborate wif executive management team to rapidly prototype business dashboards and KPIs.
• Perform quantitative analysis of product sales trends to recommend pricing decisions.
• Monitored and enhanced performance of existing Sales and Marketing models including customer life time value models and retention models using statistical techniques.
• Develop and implement data collection systems and other strategies that optimized statistical efficiency and data quality.
• Made use of teh aggregated tables on teh most frequently queried data for Monthly and Yearly based reports.
• Recommend additional methods to analyze collect and manage data to improve data quality and efficiency of teh data systems across teh application.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQLDCL, DDL, and DML requests.
• Used Database Delegation property for teh objects that involves ratios or averages.
• Created Reports using combined Queries, Slice and Dice, Drill Down, Crosstab and Master Detail Reports.
• Made use of alerts, filters and Breaks in teh reports.
• Co-ordinated wif teh Business users for teh UAT testing.
• Designed and developed database models for teh operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate wif offshore team

Data Analyst

Confidential, Chicago

Responsibilities:

• Worked in Various stages of Data warehousing life cycle of development database logical and physical design, ETL process, performance tuning on Windows NT.
• Created Mapping Documents, ETL technical specifications and various documents related to Data Migration.
• Provided support to Data Architect and Data Modeler in designing and implementing Databases for MDM using ERWIN Data Modeler Tool and MS Access
• Involved in teh Database Designing (Relational and Dimensional models) using Erwin.
• Performed data analysis and data profiling using complex SQL on various source systems including Oracle and Netezza.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Managed, updated and manipulated report orientation and structures wif teh use of PivotTables and V-Lookups.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail&Pivotreports.
• Implemented very advanced and complex queries in DDL and DML involving Joins, Subqueries. Alter Table etc.
• Active involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes as tuned and optimized SQLstatements.
• Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
• Created T-SQL stored procedures to improve teh performance of aggregate queries dynamically.
• Assisted in logical and physical Modeling for OLAP and OLTP systems.
• Extensively worked on teh ETL mapping, source data analysis, source to target mapping and documentation of OLAP reports requirements.
• Experience in Data Visualization including producing tables, graphs, listings using various procedures and tools like Tableau.
• Worked wif Tableau Report Writers to test, validate data integrity of reports.
• Support for teh development, pre-production, and teh production databases.

Data Modeler / Data Analyst

Confidential - Atlanta, GA

Responsibilities:

• Gathering teh requirements from teh Business users and understanding teh functionality of teh business
• Preparing required functional design documents and technical designed documents
• Using Power Query and Azur Machine Learning Studio for cleaning teh data to prepare teh data for creating reports
• Using SQLstatement to create relationship between teh tables and creating derived tables according to teh requirement
• Creating rich dashboards using Tableau Dashboards
• Performed data profiling in teh source systems that are required for Data Marts.
• Documented teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked wif internal architects and assisted in teh development of current and target state enterprise data architectures.
• Worked wif project team representatives to ensure that logical and physical data models were developed in line wif corporate standards and guidelines.
• Performed data analysis and data profiling using complex SQL on various sources systems.
• Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues.
• Involved in defining teh source to target data mappings,business rules, and data definitions.
• Responsible for defining teh key identifiers for each mapping/interface.
• Responsible for defining teh functional requirement documents for each source to target interface.
• Reverse engineered all teh Source Databases using Erwin.
• Documented data quality and traceability documents for each source interface
• Involved in data warehouse design.
• Documented teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked wif internal architects in teh development of current and target state data architectures
• Used data analysis techniques to validate business rules and identified low quality missing data in teh existing Amgen enterprise data warehouse (EDW).

Data Modeler / Data Anlyst

Confidential - Fairfield, CA

Responsibilities:

• Team member of teh BI module and involved in analysis of business requirements, metric matrix, and dimensionality modeling.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links wifin Interactive Dashboards.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for teh maximum efficiency and fast response using Oracle Hints, Explain plans.
• Used Teradata as a Source and a Target for few mappings. Worked wif Teradata loaders wifin Workflow manager to configure Fast Load and Multi Load sessions.
• Load data from MS Access database to SQLServer2005 using SSIS (creating staging tables and then loading teh data).
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Migration of MS Access to SQLSERVER2012.
• Requirements gathering, analysis, Use Cases, data mapping, and workflow diagramming.
• Data quality analysis and execution of teh Data Quality Management (DQM) package.
• Wrote SQL queries using analytical functions.
• Designed interactive dashboards in Tableau using drill down, prompts, filters and variables.
• Managed customer expectations proactively to maintain high satisfaction.
• Unit testing and monitoring performance and providing System support. Validated accuracy of data to ensure database integrity.
• Involved in data model reviews wif internal data architect, business analysts, and business users wif in depth explanation of teh data model to make sure it is in line wif business requirements.
• Worked at conceptual and physical database level to implement and build corporate enterprise information strategies.
• Produce SQL needed indices for data analysis purposes.
• Conducted several Physical Data Model training sessions wif teh ETLDevelopers. Worked wif them on day-to-day basis to resolve any questions on Physical Model.

System Analyst

Confidential

Responsibilities:

• OABSAnalytics team is mainly into reporting and creation of dashboards and Digitization of reports for all teh Practices.
• Design and develop teh Headcount reports for worldwide regions and for all teh practices.
• Validation of data to check teh accuracy of it.
• Analytics team is mainly into reporting and creation of dashboards and Digitization of reports.
• Automate report to pull data from database directly to excel and make teh formatting and other changes to teh report.
• Design and develop teh sales standard reports for APJ regions and area across teh client locations.
• Prepare teh Weekly monthly and fortnight sales report.
• Validate teh report in order to check teh accuracy of it.
• Identify trends and present results in chart format.
• Manage, organize & update relevant data to support business activities
• Check source data in order to validate completeness & accuracy
• Involved in automation of reports, was a go to person for all automation on all MS office tools.
• Worked on VBA projects as integration of Excel-PowerPoint and Excel-Access etc.
• Used charts, Pivots and other complex excel function to automate and improve teh productivity of teh team.
• Frequent adhoc request to support key business requirement.
• Providing Content and Data Management services to Ford of Europe being in Marketing Sales & Service team.
• Involved in report writing and business process development.
• Modified reports and make proper evaluations.
• Validated data to ensure teh quality, validity and accuracy of content.
• Claim processing for both Indian and European market (Retail Claims, Fleet Claims, and Warranty Claims etc.)

SQL Developer

Confidential 

Responsibilities:

• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Created SQL Server Reports and designing stylish report layout parameterized, performance, Ad-hoc reports.
• Worked wif Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions
• Used SSIS and T-SQL stored procedures to transfer data from source databases to teh staging area and finally transfer into teh data warehouse.
• Developed and deployed data transfers packages to teh appropriate destinations using SSIS.
• Created SQL server configurations for SSIS packages.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, and Views.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into teh Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Subreports using Global Variables, Expressions, Functions, Sorting teh data, defining data source and subtotals for teh reports using SSRS 2008/2005.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS)
• Worked wif business users to understand metric definitions, presentation, and user needs.