PROFESSIONAL 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 the Business Requirements with 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 the 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 Confidential Excel.
• Strong understanding of data warehousing concepts, OLTP and OLAPdata models.
• Excellent Software Development Life Cycle (SDLC) with 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 with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with 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 the 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 the queries in Oracle, SQLServer2008, Teradata and Confidential 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 the 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: Confidential Office (Windows, Word, Excel, PowerPoint, Visio, Project).

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

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

Database Development: T-SQL and PL/SQL, Confidential 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, Redmond,WA

Responsibilities:

• Identify, analyze and interpret trends or patterns in complex data sets in MS Excel using Pivot tables.
• Work closely with management to prioritize business and information needs.
• Derived streaming data insights and stories dat drive business decision and usability improvement of the streaming app from all aspects of the 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 the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Used the Data Warehousing Lifecycle to identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the 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 with 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 dat optimized statistical efficiency and data quality.
• Made use of the aggregated tables on the 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 the data systems across the 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 the objects dat 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 the reports.
• Co-ordinated with the Business users for the UAT testing.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate with offshore team

Data Analyst

Confidential, Bar Harbor,Maine

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 the 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 with the 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 the performance of aggregate queries dynamically.
• Assisted in logical and physical Modeling for OLAP and OLTP systems.
• Extensively worked on the 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 with Tableau Report Writers to test, validate data integrity of reports.
• Support for the development, pre-production, and the production databases.

Data Modeler/Data Analyst

Confidential - Atlanta, GA

Responsibilities:

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

Data Modeler/Data Analyst

Confidential - Fairfield, CA

Responsibilities:

• Team member of the 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 within Interactive Dashboards.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure Fast Load and Multi Load sessions.
• Load data from MS Access database to SQLServer2005 using SSIS (creating staging tables and tan loading the 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 the 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 with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with 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 with the ETLDevelopers. Worked with 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 the Practices.
• Design and develop the Headcount reports for worldwide regions and for all the practices.
• Validation of data to check the 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 the formatting and other changes to the report.
• Design and develop the sales standard reports for APJ regions and area across the client locations.
• Prepare the Weekly monthly and fortnight sales report.
• Validate the report in order to check the 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 the productivity of the 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 the 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 with Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions
• Used SSIS and T-SQL stored procedures to transfer data from source databases to the staging area and finally transfer into the data warehouse.
• Developed and deployed data transfers packages to the 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 the 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 the data, defining data source and subtotals for the 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 with business users to understand metric definitions, presentation, and user needs.