PROFESSIONAL SUMMARY:

• Over 6+ years of experience as a Business Analysis/Data Analyst/ Sql Developer/ Tableau Reporting Analyst with solid understanding of Data Modeling , Evaluating Data Sources and strong understanding of Data Warehouse , ETL, Tableau 9.3,9.X , BI , OLAP , Tableau Server
• Strong Knowledge and Experience in entire Software Development Life Cycle (SDLC)
• Strong experience in using Agile/Scrum methodology and well versed in writing user stories
• Solid Experience in writing SQL queries in Oracle , SQL Server and Teradata .
• Strong working experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch.
• Experienced in Java scripts and Cascading Style Sheets for redesigning the SAP Design Studio components color and font size as per the client's design team specifications
• Expertise in Tableau, Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, Business Objects, Unica, Google Analytics, Toad, Microsoft Office Suite.
• Have strong working knowledge on SAS Data integration studio in extracting data
• Experience with SAS Business Intelligence Platform: SAS add - in for Excel, Information Maps, Web Report studio, Dashboards, OLAP Cubes
• Experienced in Data Warehouse Environment including Data Analysis, Data Modeling, Data Mapping, Data Integration and Data Migration using ETL tool - Informatica
• Experienced in analyzing business requirements, Entity Relationship diagram and implementing them to Salesforce custom objects , Junction objects, master-detail relationships, lookup relationships.
• Worked extensively on various salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads, Campaigns, Reports and Dashboards
• Implementing Transactional and Snapshot Replication and Performed Log Shipping as Disaster Recovery Solutions.
• Experience in working with Excel Pivot Tables for various business scenarios.
• Expertise in Data Manipulations using SAS data step, such as SAS Formats/Informats, Merge, Procedures like PROC APPEND , PROC DATASETS , PROC SORT , PROC TRANSPOSE .
• Experience in developing predictive models like Decision trees, Interactive decision tree, Gradient boosting, Regression, Neural networks etc using SAS enterprise miner.
• Experience in developing programs by using SQL, SAS & shell scripts and scheduling the processes to run on a regular basis.
• Worked in creating different Visualizations in Tableau using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports.
• Experience in creating Ad-hoc reports, subscription reports by using Report Builder in SSRS.
• Extensively used Teradata, SQL, BTEQ for the backend process to build the business rules
• Performing Ad Hoc reports by using Oracle, Teradata, BTEQ , and UNIX .
• Oracle Developer including SQL, PL/SQL, SQL *Plus Editor.
• Database analysis tools TeradataSQL Assistant, TOAD and ERwin . Data cleansing tool WinPure.
• Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
• Prepared scripts to ensure proper data access, manipulation and reporting functions with Rprogramming languages .
• Formulated procedures for integration of R programming plans with data sources and delivery systems.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Business/Data Analyst

Responsibilities:

• Involved in the cloud migration of Operational and Analytical Data of COF Financial Services using SPARKS SQL, AWS Cloud Services and Zeppelin.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping.
• Extensively worked on documenting the Metadata into Nebula Template where all the data set registration and metadata capture related to business, technical and data classification was stored and migrated it to Nebula from metadata hub as it was being decommissioned.
• Involved in created Data Lineage, which is primarily used for moving the data standards for data traceability and was extensively involved in impact analysis, source to target by applying various transformation rules and all the data from the source centric platform is transformed and all the transposed data has been copied to Snowflake model.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and cross Joins and transformed this queries into Sparks SQL in order to read the files from AWS and apply the transformation logic as a part of cloud migration project.
• Good experience in using Aggregates, Analytical funtions like RANK, DENSE RANK, Sequence in the queries.
• Was involved in creating lot of web-based notebooks that are used for interactive data analytics and collaborative documents using APACHE Zeppelin, Sparks SQL and Scala.
• Expert in all areas of SQL Server/Teradata development including Tables, Derived Tables, views, stored procedures and maintaining the data integrity.
• Responsible for working with customers to gather the requirements and created functional specifications and created the dashboards using Tableau.
• Expertise in creating Dashboards reports to support the end users and customers using Tableau Desktop.
• Involved in creating lot of documents related to COF cloud migration project using cartographer, Nebula, ILDM and Data Lineage documents that is mandatory for the migration project.

Confidential, Bloomington, IL

Business/Data Analyst

Responsibilities:

• Actively involved in analyzing Physical and Logical models using MDR.
• Involved in the daily discussion on the certification process and getting approval from data management counsel.
• Transform Business Analyst documentation and requirements into ANSI SQL code for marketing segmentations
• Involve in Planning, Defining and Designing database based on business requirements and provided documentation
• Data processing and analysis were done using advanced algorithm and predictive analysis such as python Language.
• Performing data analysis and data profiling using ANSI SQL on various sources systems including Oracle and Teradata
• Existing system in Oracle Migrated to Hadoop .
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Design job flows using SAS/DI to extract data from source systems, perform required transformations and load back to target.
• Use SAS/BRM to integrate all the business rules and then invoke them back into SAS DI jobs.
• Groomed and managed user stories utilizing Rally agile planning tool.
• As Scrum Master communicated dependencies and potential risks to the completion of the sprints including resources, costs and systems.
• Performed the roles of Salesforce Analyst, Administrator and Configuration specialist in the organization.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Continuous monitoring and managing the Hadoop cluster using Cloudera Manager.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Executing manual test scripts using JIRA and logging defects in the same.
• Logging Defects in JIRA and following till the closure.
• Conducted workshops to understand requirements for Data Warehouse design , conducted client-side validation to study ETL (Extract Transform and Load) operations on database.
• Worked on various sales force objects like Accounts, Opportunities, Products and Reports.
• Analyzing the profiling results in Informatica Analyst and Cognos reports to address the related issues.
• Aggregate with reporting tools, performed server data integration using Python/SQL .
• Summarization between lightly detailed data and highly summarized data done using Metadata .
• Manages the flow of information between departments using relational databases .
• Developed PM Reports based on Standard JDE reports.
• Provided support for implementing Interface between JDE system and Legacy system
• Provided subject matter expertise as appropriate to ETL requirements, information analytics, modeling & design, development, and support activities.
• Responsible for research and analysis for GIS
• Developed web based GIS application
• Indentify data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution, data classification, taxonomy services, item master creation, schema mapping, product codification, data enrichment and data governance through MDM.
• Worked with requestors to develop and understand data requirements and reports specifications
• Ensure data integrity, availability and performance of ICDW database systems by providing support and maintenance
• Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
• Resolved data issues and updates for multiple applications using SQL queries/scripts

Environment: Oracle11g, .NET, IAM, Hadoop, Java, Google Maps API, Salesforce, SAS, JIRA, HIPPA, JD Edwards, Teradata v14, BTEQ, FLOAD, LDAP, MLOAD, Teradata SQL Assistant, UNIX, Microsoft SQL server 2012/2008, Tableau 9.3, Informatica Powercenter(9.X,8.X) MS Excel, MS Word, MS PowerPoint .

Confidential, Scottsdale, AZ

Data Analyst

Responsibilities:

• Involved in integration of marketing leads by extracting them using Marketo with Salesforce.
• Identify, analyze, and track issues and solutions to problems.
• Analyzed and gathered requirement for marketing automation by using Salesforce marketing cloud.
• Managed the design and development phases of new iHub Interface Engine to save the received data into a structured database called CDR (Clinical Data Repository) and to exchange and access by HPMG downstream applications in a unified standard.
• Used SDLC Development Cycle with the .Net Frame Work 4.0
• Responsible for ER Diagrams, Conceptual, Logical and Physical Data modeling using Microsoft Visio, CA Erwin that involved requirement analysis with business team and translating them into Technical Specs
• Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
• Created ETL jobs in SAS DI based on Technical Solution Document. These jobs included coded algorithm and rules created in SAS BRM.
• Developed automated data pipelines from various external data sources (web pages, API etc) to internal data warehouse (SQL server), then export to reporting tools by Python.
• Perform ad hoc analysis to observe complex patterns and provided the summary of results with excel pivot tables, charts to show trending.
• Wrote Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files.
• Worked closely with management to prioritize business and information needs.
• Designed solution, developing code and sustainment using T-SQL and Oracle.
• Testing and validating the results from the business perspective.
• Worked extensively in sorting, merging, concatenating, and modifying SAS data sets in different environments Windows and Unix.
• Built up Python backend that connects database.
• Responsible for design, development and maintenance of data collection systems using Erwin Data modeler, SSIS, T-SQL, PL/SQL, SQL Server
• Developed database programs like Stored Procedures, Joins, Triggers, Views, Cursors, Packages and Implementation scripts on ANSI SQL, PL/SQL and T-SQL using Oracle SQL Server.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets and Data Queries using ANSI SQL.
• Defined Functional Test Cases, documented, Executed test script in Facets system
• Analyze the scope of projects, work cross-functionally with other stakeholders, develop project plans and provide time estimates.
• Establish project teams, set project schedule, estimate project resource plans, and maintain status reports for all business owners.
• Automate existing manual sales and marketing process using salesforce.com and custom development.
• Created Email templates in Text, HTML and Visual Force necessary for the application.
• Ensure projects deliver the business operational needs and requirements. Ensure adherence to quality standards and reviews project deliverables from a business standpoint.
• Review and track status of projects and deliverables and provides project updates to businessmanagement and Senior PMO Leadership in conjunction with overall strategic initiatives reporting.
• Create presentations regarding project status and current issues.
• Effectively escalate project risks and are as requiring Senior Project Management intervention.
• Identify repetitive questions and/or problems and recommend process improvements so corrective action can be pursued and expedited.

Environment: Salesforce, Hadoop, .NET, Java, Validation Rules, SAS, Tableau, Sharing rules, Reports, Project Plans, Marketing, HTML, Visual Force.

Confidential, Atlanta, Georgia

Business Analyst/Data Analyst

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse.
• Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all the environments for SQL Server 2000.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Created report form with Stored Procedure using T-SQL
• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Gathered requirements and created design plan for the database design and required analysis for generation of reports
• Designed, developed and modified various Reports.
• Managing daily team meetings and involved in the business requirement meetings
• Handled and managed customer relationship management system.
• Designing and modeling database according to Requirement. And made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports.
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Environment: MS SQL Server 2000/2005, MySQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).