SUMMARY:

• Versatile & result - driven Data & Management professional with over 8 years of experience in data analysis, data formatting and reporting and writing Complex SQL queries and SAS/BI tools.
• Expertise in implementing projects by following SDLC & Agile methodologies.
• Strong experience in Banking and Financial domains.
• Built various SQL scripts to run a variety of ad hoc reports as per the client's request.
• Evaluated and analyzed the volume of customers and performance cycle periodically by building high-level queries in Oracle to render logical statistics.
• Over 8 years of experience in Analysis, Design, Development, Testing, Implementation, and support of IT applications and product developments.
• Experienced in Performance Analysis and SQL query tuning, designing scalable applications from scratch and maintaining existing ones.
• Experience and thorough understanding of working with Agile methodologies and participating in daily SCRUMS.
• Experienced with Data Warehousing, Fact and Dimension tables, Star and Snowflake schema.
• Extensively used Tableau and MS Excel for Data Analysis and to create Reports.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Experience in the design and deployment of Unix Shell Scripts.
• Experience in gathering and creating Business Requirements and translating business requirements into technical requirements and writing functional and technical specifications.
• Performed various types of testing, such as functional, system, regression and user acceptance testing.
• Experienced in Training, Documentation, and Implementation in a business environment.
• Solutions-oriented IT Professional with around 8 years of experience and proven success designing, implementing and integrating cost-effective, high-performance technical solutions to meet challenging business needs.
• Solid technical background with a solid history of delivering outstanding customer service.
• Genuine commitment to quality and customer satisfaction
• Have proven knowledge of data analysis and won accolades for providing the best solutions that helped the organization in making important business decisions.
• Have given data visualization solutions to Business partners to help them understand easily.
• Interact with Subject Matter Experts (SME) to gather Business Requirements for the application, through one-on-one interviews and worked on developing the business rules for cleansing.
• Have strong financial industry experience (Retail Bank/Credit card)
• Implement best/time efficient solutions for the collected business requirements.
• Demonstrated ability to satisfy users through analysis and problem resolution.
• Recognized as the "go-to-person" for an immediate resolution to technical issues.
• Organized, take-charge professional with exceptional follow-through abilities and detail orientation, able to plan and oversee projects from conception to successful conclusions.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2012/2008/2005 , Oracle11g/10g/9i

Languages: SQL, PL/SQL, HSQL, MySQL, UNIX, Hive, Impala

Scripting: SQL, Shell, Python

Cloud Technologies: Hadoop, AWS (S3, Redshift, Snowflake, EC2

Data Analysis: SAS, MS Excel, Tableau, Data Warehousing

TOOLS: Tableau desktop/server, SQL workbench, MS Office, MS Visio, MS Access, MS Word

Defect/Change Tracking: JIRA

Methodologies: Agile, Waterfall

Operating Systems: UNIX IBM AIX 5.2, HP: AIX, Windows 10Pro/7/9x/NT/2000/XP/ UX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Data Analyst

Responsibilities:

• Responsible for technical data governance, enterprise-wide data modeling and database design and developed multi-dimension data models to support BI solutions developed as well as other common industry data from external systems.
• Working with business partners and team members, gather and analyze requirements translating these into solutions for database designs supporting transactional system data integration, reports, spreadsheets, and dashboards.
• Involved in Planning, Defining and Designing database using Erwin on business requirement and provided documentation.
• Designed the WellPoint Facets domains Member, Provider, Claim, Product, Billing, Group conceptual and logical model for categorizing and mapping automated business processes Jobs, user reports and application processes to the appropriate domain entities using Erwin.
• Derived logical data model from the physical data model through the manual reverse engineering process.
• Loaded data into Hive Tables from Hadoop Distributed File System (HDFS) to provide SQL access on Hadoop data
• Advanced information management and new data processing techniques may be applied to extract the value locked up in this data called Hadoop (HDFS) along with processing large data sets in parallel across a Hadoop cluster and the utilization of Hadoop MapReduce framework.
• Worked with project management, business teams, and departments to assess and refine requirements to design/develop BI solutions using Tableau.
• Researched and developed hosting solutions using Tableau and other 3rd party hosting and software as a service solution.
• Used SQL on the new AWS Databases like Redshift and Relation Data Services and worked with various RDBMS like Oracle 11g, SQL Server.
• Created SQL tables with referential integrity and developed SQL queries using SQL Server and Toad
• Worked with PivotTables working with up to 140 million-record, multi-table, data sets in SQL (MS SQL Server, SAS Proc SQL, etc.)
• Created Tabular Data Models and implemented Tableau for POC in Share Point Environment
• Partnered directly with the Data Architect, clients, ETL developers, other technical data warehouse team members and database administrators to design and develop high performing databases and maintain consistent data element definitions
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Created logical and physical data models and reviewed these models with the business team and data architecture team.
• Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.
• Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues.
• Responsible for full data loads from production to AWS Redshift staging environment and responsible for creating Hive tables, loading data, and writing hive queries.
• Designed different types of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
• Produced and enforced data standards and maintain a repository of data architecture artifacts and procedures.
• Provides architectures, patterns, tooling choices and standards for master data and hierarchy life cycle management.

Environment: Power Pivot, SQL, MS Excel, Facets, Tableau, CSV files, Hadoop, AWS, Redshift, Python, XML files, Linux, Teradata SQL Assistant, Oracle12c.

Confidential, Denver, CO

Programmer Analyst

Responsibilities

• Created Summary Reports and Tabular Reports to clients based on their business requirements.
• Provided Data Analysis and Designed and developed various Business Reports.
• Designed/Developed SQL scripts to move data from the staging tables to the target tables.
• Fine-tuning of SQL to optimize the performance, spool space usage and CPU usage
• Designed the order of flow for the execution of the jobs and scheduling the jobs.
• Performed data validations, Data integrity before delivering data to operations, financial analyst.
• Involve in data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting and graph, and chart manipulation.
• Develop Complex SQL queries, Stored Procedures, Packages, Functions and Database Triggers.
• Used different joins for creating views from multiple tables.
• Wrote several SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request, queried the database objects to validate the data quality.
• Involve in performance tuning of slow running SQL Queries.
• Involve in the development of PL/SQL scripts for pre-& post-session processes to automate loads.
• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on the status of the projects.
• Analyzed report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, MS Access, PowerPoint and UNIX.

Environment: SAS, SQL Queries and MS Excel, MS Access, PowerPoint, Tableau, VB Scripting, Macros.

Confidential

Business Data Analyst

Responsibilities:

• Understand the data visualization requirements from the Business Users.
• Analyze Sales data mart model to identify the tables and their relations in order to extract required data.
• Writing SQL queries to extract data from the Sales data marts as per the requirements.
• Create Source to Target Data mappings for the individual reports.
• Create Pivot tables in Excel to analyze data across several dimensions.
• Building Dashboard/Stories over data using Tableau and Excel.
• Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and another Chart.
• Maintained data integrity during extraction, transformation and loading of data into data warehouse and engaged in requirements and gap workshops with clients for identifying the data sources and data needed for analysis.
• Developing tidy dataset, Data visualization in Tableau using various packages.

Environment: Oracle, SQL, Tableau, Excel