SUMMARY

• Highly motivated, attentive, and dependable Data Analyst wif 8+ years of IT experience, wif expertise in data analysis, data warehousing, & Business Intelligence applications, reporting, and process.
• Exposure to overall SDLC process including requirement gathering, analysis, development, testing, debugging, deployment, implementation, and production support.
• Knowledgeable in System Development Life Cycle (SDLC) including all phases of Waterfall, Agile and Scrum.
• Strong background in statistics and mathematics.
• Involved in various projects related to Data Design, System/data analysis, design, and development for data warehousing environment.
• Experienced in process improvement, normalization, data extraction, data mining, data cleansing and data manipulation.
• Documented data source definition and ETL specification, transform and load data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica PowerCenter.
• Good understanding of views, Synonyms, Indexes, Joins, Partitioning, and Proficient in Tableau, SAS, Python and advanced excel.
• Experience in SQL Server DTS and SSIS package design, constructing and deployment, running SQL query and testing SQL Server for data validation.
• Used incremental approach in teh Workflows and Data Flows to integrate source data into warehouse tables using required transformations.
• Create Access front end to allow simple, quick, repetitive SQL query for non - technical personnel.
• Provided support in analyzing large datasets and developing insights into business performance.
• Advanced in Microsoft office (Word, Excel, Power Point, Outlook, MS project & Visio).
• Excellent communication, analytical, problem solving, cross functional and interpersonal skills wif clear understanding of business processes and ability to work as part of team or individually.

TECHNICAL SKILLS

ETL Tools: Sql Server Integration Services (SSIS), IBM DataStage, Informatica Power Center

Databases: MS-Access, Microsoft-SQL Server 2008 R2/2012/2014, DB2

Reporting: Sql Server Reporting Services (SSRS), Business Objects, Power BI, Tableau, SSAS, MDX query, Erwin tool

Operating System: Windows 10 Professional/ 7 Professional/ 9X/2000/XP/VISTA, UNIX

Other: Visual Studio, SPSS, MS-Office (MS-Excel, MS-Access, MS-Word and MS-Outlook), Toad, Visio, OneCRM/Salesforce

PROFESSIONAL EXPERIENCE

Confidential

Data and Logistics Analyst

Responsibilities:

• Manage customer billing and perform data entry functions in OneCRM/Salesforce
• Utilize OneCRM to manage customers, vendors, suppliers through buying lifecycle.
• Liaise between sales teams, operations, clients, and carriers.
• Create and deliver solutions to customers and sales teams.
• Conduct daily delivery reports using Excel.
• Use Excel formulas to run and display customized quotes and other data.
• Monitor progress of delivery routes.
• Responsibilities included involvement in entire Software Development Life Cycle.
• Responsible for inquiring, managing, manipulating, and analyzing data and reporting results.
• Involves in defining teh table/file layouts by understanding teh requirements in creation of outbound files and loading data into Data Warehouse.
• Develop data structures and models to represent teh regulation
• Modify teh existing database by adding teh tables and maintained relationships between teh tables.
• Analyze database requirements in detail wif teh project stakeholders by conducting Joint Requirements Development sessions.
• Develop normalized Logical and Physical database models.
• Work wif Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate teh developed models.
• Identify, formulate, and document detailed business rules and use cases based on requirements analysis.
• Responsible for defining teh naming standards for data warehouse.
• Generate ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Prepared analytic dashboards, reports and visualization using SQL, Power BI, and MDX query.
• Exhaustively collected business and technical metadata and maintained naming standards

Environment: DB2, MS-Access, Microsoft-SQL Server 2008 R2, SQL Server, DataStage, MS Excel, WINDOWS 2007, UNIX, OneCRM

Confidential

Data Analyst

Responsibilities:

• Teh sole data analyst and liaison between business operations and corporate headquarters
• Provide complex analysis and translates information wif detailed specifications.
• Capture, record, sort, and filter data.
• Manipulate and analyze large data sources from multiple system platforms.
• Create reports for business leadership around productivity, inventory, forecasting and other ad hoc reporting.
• Liaison between operations and its customers to partner and align solution strategies.
• Perform manual data entry in excel and converts wifin company-specific software.
• Use Excel on a day-to-day basis to perform VLOOKUP functions.
• Use Pivot Tables to summarize and analyze data in Excel.
• Actively and consistently supports all efforts to simplify and enhance teh customer experience
• Assists in process improvement efforts to reduce redundancy and waste wifin teh business
• Assists wif new client onboarding
• Subject Matter Expert (SME) and Task Force Leader for inventory systems and processes
• Received multiple accolades and career progression for efficiency and outstanding performance
• Generated various reports for Director and senior leadership to provide growth, profit, performance, and sales.
• Performed strategic and statistical analysis by using advanced excel.
• Worked wif clients, end-users, technical architects, and developers to define teh data requirements and structure for Business Intelligence (BI) Application.
• Maintained internal server and database for new products, promotions, and policies.
• Collected business and technical metadata and maintained naming standards.
• Created various data modeling process using Erwin tool and used SQL server analysis service (SSAS) for making cube.
• Facilitated development, testing and maintenance of quality guidelines and procedures along wif necessary documentation.
• Involved in defining teh table/file layouts by understanding teh requirements in creation of outbound files and loading data into Data Warehouse.

Environment: BI, NDCP, CML, SSAS, DB2, MS-Access, Microsoft-SQL Server 2008 R2, SQL Server, DataStage, MS Excel, WINDOWS 2007, UNIX.

Confidential

Logistic and Procurement Lead

Responsibilities:

• Monitored use of materials and resources to ensure quality record keeping in Excel.
• Utilized teh data in Excel to summarize and analyze data as well as create visualizations for customers.
• Identified and developed strategies for addressing logistical barriers
• Identified and evaluated suppliers and arranged for transportation of purchased goods
• Led business development, marketing, and sales efforts
• Relationship management to promote business and enhance customer experience
• Monitored and resolved all customers invoice data issues

Confidential

Data Analyst

Responsibilities:

• Coordinated wif engineering and product management teams to ensure accuracy on deliverables and to prepare summaries
• Performed data analysis and facilitated in delivery to all end users
• Monitored and organized all client invoices and performed timely assessment payment issues
• Maintained and documented library of invoices and resolve all issues
• Develop and maintain data flow models to evaluate data, provides a consistent base line for prioritizing projects and allocating resources, and evaluate different risk level opportunities for Users.
• Worked wif advanced queries in MySQL database and experienced wif Microsoft SQL reporting Services.
• Event handlers, which are workflows that runs in response to teh events raised by a package, task or container in SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension wif teh SSIS slowly changing Dimension
• Wizard and used different SSIS Control Flows.
• Worked on Data Profiling in SSIS and applied Fuzzy Lookup.
• Loaded RAW Files into SQL Server using SSIS
• Worked wif teh Business Users gathering their requirements and actively cataloging and supporting various issues and documented teh requirements.