SUMMARY:

• Overall 9 years of rich experience as Data Analyst and Data Modeler. Comprehensive knowledge on several business areas, with Telecommunication, Retail, Banking and Finance being the strongest.
• Solid Experience in the subject area of Business Intelligence Data warehousing, Reporting (Tableau) and ETL process as Data Analyst
• Extensive knowledge on Data warehouse Concepts such as designing and implementation of Data Marts with Star, Snow flake schemas and thorough understanding of new age Data warehouse concepts like RDM, MDM, ODS, RDWs
• Proficient across the entire pipeline from data wrangling, feature selection, model evaluation, API creation, up to data product
• Expertise in building complex SQL Queries to perform data mining, data analytics, and data extractions across databases using WinSQL, Putty and Dbeaver
• Extensive experience on building dashboards using Tableau from various database (MELD, HIVE and Vertica)
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Proficient in writing complex SQL queries, stored procedures, normalization, database design, creating indexes, functions, triggers and sub - queries.
• Proficient in tuning queries used in the application
• Experience in Developing, Analyzing and programming Machine Learning Algorithms based on Supervised an Unsupervised Learning
• Professional experience of working on different SDLC methodologies such as Agile (Scrum), Waterfall & Rational Unified Process
• Highly capable of facilitating Joint Application Development & Modeling (JAD, JAM) sessions, Requirements Workshop sessions, user interviews and of acting as a liaison between the clients, Managers, Consultants, End users, Developers, QA and all other stake holders of the project.
• Proficient in preparing Test Scenarios, Test Cases, & Test Artifacts for successful execution of the product.
• Involved in User Acceptance Testing (UAT) and in various testing strategies. Knowledge in software testing, process testing and quality control.
• Competent in providing complete solutions to satisfy all Business and Technical needs including: writing and running SQL, BI and other reports, analyzing data, creating metrics/dashboards/pivots/etc.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Data Analyst/SQL Analyst/Data Modeler

Responsibilities:

• Collecting the requirements from the internal stakeholders, sourcing the Data, ETL it into Vertica environment, and then building Data Visualizations on top of it.
• Calculated and created demand data for various service flows at Region and Natioal Level
• Aggregated the view to pull up and aggregate data at weekly and monthly level. Developed automation in Unix script to populate the dashboard on weekly basis
• Developed complex queries to perform calculations from tables and calculate the demand at service level
• Created visualization in tableau, after integrating the data from from views that were created in vertica database
• Generated area, geo and bar plots for the Traffic KPI Dasboard and pulished it to Confidential server with daily refresh.
• Performed UAT on data warehouse and source system queries/reports/screen prints are filed for bug research
• Designed Summary and Detailed reports using Data Blending feature in Tableau
• End to end experience in designing and deploying data visualizations using Tableau
• Generated Dashboards for Traffic data with Quick filters, Parameters and sets to handle views more efficiently.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server

Confidential, Atlanta, GA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Gathered requirement and analyzed the scope of Business specification. Developed Technical Architecture for ETL for source data, staging, Dimensional data store Schema and DBMS
• Developed ETL Strategy and plan derived from user requirements and technical architecture that is needed to support ETL process
• Developed ETL Design and rules for moving data into target data warehouse
• Creating Transformation of types Aggregator, Sorter, Filter, Router, Rank, Look up and Stored Procedures
• Implementing various types of Data Transformation Formatting, Derived, Default, Validation and Cleansing
• Loading data using Full / Incremental and Replace / Append Approach
• Implemented Slowly Changing Dimension Type 1, Slowly Changing Dimension Type 2 and Slowly Changing Dimension Type 3 using ETL
• Loading various Fact tables (Fact Load, Snapshot Load, and Aggregate Load). Implementing Normalization on the Fact table
• Designing Star Schema and Snow Flake Schema on Dimensions and Fact Tables. Was involved in all the three stages of Data warehousing
• Analysis, reporting and tracking of defects on a daily basis. Creating, adding task and session task in a ETL workflow
• Monitoring code using ETL workflow Monitor screen. Debugging ETL session and ETL workflow run properties for errors and fixing the errors
• Handled error using Validation Rules, Translation, and Rejecting the data
• Reconciliation of data in Data warehouse with data in Source using complete reconciliation and stage reconciliation
• Optimizing and performance tuning of the data. Coordinate with the various project teams to ensure full coverage. Responsible for reproducing production bugs and validate bug fixes.
• Handling up module independently and taking up the responsibilities.
• Have provided knowledge transfer to the team members. Logging defect and tracking the defects through QC.
• Rebuilt the existing UNIX scripts to run the ETL Process. Compared "standard" reports/queries in the data warehouse to specified source system reports
• Developed data warehouse queries and compared to specified source system reports

Confidential, Boston, MA

Data Analyst/Developer

Responsibilities:

• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables and to prepare Test Cases.
• Worked closely with the business users to understand the requirements and converting them into project level technical capabilities
• Actively participated in the Team meetings to gather business requirements and in developing the Specifications.
• Extensively worked with Data Stage Job Sequences to Control and Execute DataStage Jobs and Job Sequences using various Activities and Triggers.
• Using Shell programming, worked on development of batch programming, where data stage jobs called from UNIX shell programs in batches.
• Performed Unit testing of DataStage Jobs using Unix Shell Scripting and with web application to ensure that it meets the requirements.
• Working with stages like Complex Flat File and Transformer, Aggregator, Sort, Join, Lookup, and Data masking pack.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.
• Performed in writing complex SQL queries involving multiple tables inner and outer joins.
• Assisted in configuration, development and testing of Autosys JIL and other scripts.
• Participated in complete process of functionality testing of all versions of AutoSys applications.
• Extensively used Control-M for automation of scheduling UNIX shell script jobs on daily, weekly monthly basis with proper dependencies
• Interact with multiple teams DBA, Middleware and Reporting for the design and end to end implementation of solution

Confidential, Kennesaw, GA

Analyst/Developer

Responsibilities:

• Our team involved in Confidential analysis for confidential families of companies and confidential.
• Based on the analysis done during the requirements phase, the impact to scope, schedule to be derived and provided to AMFC.
• Any module needs to be developed using other or similar existing technology which becomes known after the completion of design phase.
• At the end of the 'Confidential Analysis' phase, our team will validate the proposed solution, scope and any assumptions made during proposal submission
• Gathering the requirements and interacting with business user to understand requirements and design, development and documentation.
• Designed, Developed, Tested ETL jobs using Datastage according to technical design documents. Used DataStage Director and scheduler for running ETL jobs, monitoring scheduling and validate
• Created UNIX shell scripts to be used in conjunction with files and ETL execution scripts for automating jobs
• Extensively used Parallel Extender to load data into the data warehouse with different techniques like Pipeline and Partition in MPP environment