Highly skilled professional having experience in system analysis, design, development, and implementation of enterprise applications. Experience in Data Analyst, Big Data Technology stack, Frame work Manager, Data warehousing, ETL, BI reports, BSS support, and Project Management.
Leveraged a basic understanding of multiple data structures and sources. Maintained and assisted in the development of moderately complex business solutions, which included data, reporting, business intelligence/Big data analytics.
Creative in finding solutions to problems and determining modifications for optimal use of organizational data. Expert at providing realistic projections and establishing various scenarios to determine viable process strategies to utilize.
Experience on creating Source to Target mapping documents, gathering business requirements from business/user, creating Process Flows and Data Flow Diagram.
Worked with MDM and Ref Data as per the business need.
Requirement gather from regulatory bodies, identified the reports and columns impacted in database.
Updated metadata as per the data definitions and logical names for all the impacted column elements in the Master database.
Coordinated with business to make sure the definitions are as per the context.
Updating monitoring rules for all the columns, verified the current and Target databases are updated and validated the data matches
Worked in different relational databases environments such as Oracle, SQL Server, and My SQL.
Experienced in working third party database management tools such as Oracle SQLdeveloper .
Worked on implementing ETL methodologies using SSIS, and Talend, and Knowledge on Informatica Power Center.
Extensive experience as a DWH Technical Analyst, provided Business Intelligence and Data Warehouse solutions using Microsoft Data Tools, IBM Cognos FM, and BI reports (Cognos Report studio, Tableau, Power BI).
Experienced in Data modeling knowledge of Ralph Kimball's Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
Experienced in Erwin data Modeling iterations (Schematic/ Logical/ Physical) Forward and reverse-engineering process.
Experienced in Project Management, Change Management, Vendor Management, Agile Scrum master, Business analyst and Data Analyst, and knowledge on SDLC and STLC.
Expertise in Big Data solutions in building scalable distributed data processing solutions with Hadoop.
Working on Cloudera Manager Bigdata Hadoop Distributor,Knowledge on Hortonworks and Ubuntu Hadoop Distributors.
Working as a Hadoop Developer in all phases of Hadoop and HDFS development.
Working on HDFS, MapReduce and Hadoop Ecosystem Pig, Hive, Flume, Kafka, YARN, Oozie, HBase, Zookeeper and Sqoop.
Well versed with developing and implementing of MapReduce jobs using Hive and Pig to work on Big Data.
Understanding of Spark processing Framework such as Spark and Spark Sql.
Experience in NoSQL database like HBase.
Procedural knowledge in cleansing and analyzing data using HiveQL, Pig Latin, and custom MapReduce programs.
Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems such as Oracle, MS Sql, and My Sql and vice versa.
Working on Data visualization using Tableau.
Experience in Data wrangling such as reformatting data values or layout, correcting erroneous or missing values, and integrating multiple data sources.
Worked on Data wrangling methodologies using Trifacta and Talend.
Certified Scrum Master, ISTQB, and trained on PMI-ACP.
Quick learner and Good Team player.
Having Excellent analytical, problem solving, communication skills and a committed team player with ability to interact with individuals at all levels.
Work Authorization: Green card
SQL Server Tools
SQL Server Management Studio 2008/ 2012, SQL Profiler, SSRS, SSIS, and SSAS
Cognos, Tableau, SSRS, Power BI
SQL Server 2008/ 2012, My SQL, Oracle10G/11G
Data Modeling tool
CA Erwin Data modeler, IBM Cognos Framework Manager
Database Management tools
Oracle SQL Developer,Toad
Unix/Linux, Windows XP, Windows2000/98/95, Windows 7/8/10
Installed, and configured MS SQL Server 2008/2012.
Administered the SQL Server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
Created and modified database objects like tables, stored procedures, functions and triggers.
Used SQL Server Agent for scheduling jobs and alerts.
Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
Performed day-to-day production support activities that are prioritized.
Identified fact and dimensional tables and Designed warehouse with star schema.
Migrated database from SQL servers to oracle servers using SQL developer.
Created SQL queries for data retrieval and Tuning SQL queries for better performance using SQL Profiler.
Created/enhanced numerous SSRS reports to support internal business users and support team to monitor various processes.
Developed reports in SSRS and export them to EXCEL and PDF formats as requested by the business.
Created T- SQL queries, tables, Views, stored procedures and functions that are required for report generation.
Created functions for calculation purposes in SSRS.
Created Cross-Tabs, Drill-down and Sub-Reports using SSRS.
Deployed RDLs to Report Server.
Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
Created ETL packages to validate, extract, transform and load data to data warehouse and data mart.
Designed and built OLAP cubes as per business requirements and generate adhoc reports.
Designed and developed SSIS packages to move data from different environments within the organization.
Performed various SSIS tasks, data validation checks during staging, and then loaded the data into the data marts.
Transformed data from various data sources using OLEDB connection by creating SSIS packages and schedule them as per requirement.
Designed and developed OLAP cubes using SQL Server Analysis Services.
Worked on Power BI and prepared dashboards to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
Developed various data connections from data source to Tableau Desktop for report and dashboard development.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Developed various Dashboards using objects such as Chart Box (Drill Down, drill up & Cyclic Grouping), List, crosstab using Tableau.
Created dashboard reports using Tableau for Business users.
Worked on Cognos Framework Manager, Meta data Modeling, and Report studio.
Defined Database source in Frame work manager form different database server, configured Layers, packages, and DMR.
Worked on BI reports using Report studio such as List Reports, grouped reports, cross tab reports, Chart reports, Drill-Down and Drill-Through Reports.
Supported Business Users in generating Adhoc Reports using Query Studio.
created Active reports for remote users using Cognos BI.
Configured Data source connection, Security and JDBC connection using Cognos Administration.
Environment: SQLServer, SSIS(ETL), SSRS (Reports), SVN, Cognos FM, Cognos BI, Tableau, Power BI.