SUMMARY

• A meticulous Business Intelligence and Data Analytics Professional with 7 years of professional experience in Data Analytics/Business Intelligence and ETL with extensive knowledge of business process and functioning of Health Care, Manufacturing, Financial, Insurance sectors.
• Extensive and hands - on experience using Tableau, SAS, Qlik Sense, Qlik view Informatica, Talend, Amazon Redshift, SQL with extensive hands-on system analysis, data modeling, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Excellent communication skills, team management and logical ability. Responsible for collaborating with business partners/clients and other stakeholders.
• Excellent knowledge on Dimensional Modeling concepts like (Star Schema, Snow Flake Schema) & Loading Data from multiple sources.
• Good experience in creating Use Cases, process flow chart diagrams, Activity Diagrams, Sequence Diagrams, Unified Modeling Language (UML) using MS Visio and Rational Rose.
• Widespread understanding of SDLC Methodologies like Waterfall, Agile/Scrum.
• Extensive experience in Data Analysis, including profiling, cleansing, transforming and confirming.
• Experience in Data Models/ Scripting to handle high volume of data applying optimization techniques and data statistics calculations using different sources.
• Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library, QVD and QVX files. Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Upgraded Workbooks and Dashboards from Tableau 8 to Tableau 9.

TECHNICAL SKILLS

Analytical Tools: Tableau 10.5/9/8.3, SAS, Qlik Sense 1.2/2.0/3.2, Qlik N-printing, Pentaho

Languages: SQL, PL/SQL, QlikView Scripting, Python, R Programming, SAS, PL/SQL, HTML, CSS, HQL

Database Technologies: Oracle11g/10g, MS SQL Server, Netezza, PostgreSQL, DB2, MS Access, Amazon Redshift, Azure SQL

Big Data Tools: Hadoop, Hive, Splunk

Data Integration: Informatica, Talend

Operating Systems: Windows, Unix, Linux, MAC OSX

Data Modeling: ER Studio

Methodologies: Waterfall/Agile Software Development

PROFESSIONAL EXPERIENCE

Confidential, Broomfield, CO

Data Analyst/Data Scientist

Responsibilities:

• Built a dynamic dashboard over Power Bi by fetching end to end encrypted data through oracle database, increased allocation process efficiency approximately by 65%
• Enhanced and articulated system performance by analyzing potential depreciators and removed nonvalue added parameters
• Maintained dashboard-server efficiency through selecting and managing potential gateways for automatic real time reporting hence streamlined iterations according to client’s requirements
• Established a real time reporting system made of complex SQL queries thus reducing the process times and enhancing the system performance
• Designed an InfoPath form to a Share point list, added calculated columns and thereafter performed data staging on a new share point online list, also, performed data analysis and visualization on this new list using PowerBi
• Combined data from multiple source systems like Excel, oracle, SSMS, MySql to a common staging database using SSIS data flow and control flow tasks.
• Developed Power BI data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Performed prediction analysis on classification models like logistic regression and KNN means.
• Worked on libraries like Scikit Learn, Pandas and NumPy.

Environment: Power Bi, Power Apps, Power Automate, SQL Server, Oracle, MS Excel, SharePoint, Python, Predictive Modelling, NLP.

Confidential, NYC, NY

Sr Data Science

Responsibilities:

• Led multiple projects i.e. Global Pricing, Janssen Connect, Care path, iQlik and Connected Visibility.
• Worked with Business SMEs to analyze and document business requirements and functional specifications.
• Implemented the 3-tier architecture, Data Extract, Data transform and Data model & Application. Data Extract would load the Data from the data sources into the QVDs. Data transform will transform the data and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 6 hours
• As a data architect for one of the projects, designed the data flow, configuration set up, implemented best practices and coordinated with offshore developers and testing team to build reports, log and fix existing defects and enhancements.
• Expertise in QlikView Scripting, creating Qlik n-printing reports, Set analysis and Section Access and in database programming, SQL, Tables, Views, Indexes, Joins, and Sub - Queries.
• Designed and implemented the Incremental Load using QVDs to decrease the load time / increase loading performance, so that Qlik sensewould only load the data worth of one day and append it to the old data which is already stored in QVDs.
• Performed different tasks like extraction, reload tasks, distribution tasks, reduction, deploying apps, scheduling, User management, license management, Clustering and licensing using QMC, tested applications using review checklists, Data quality for Quality Assurance before delivering to the end users, analyzed the data and defined Key Performance Indicators (KPI).
• Increased performance in QlikView / Qlik Sense application by exporting complex calculations to views and stored procedures in the Amazon Redshift Database. Designed and developed Qlik Sense application based on existing QlikView data model. Scheduled the jobs and distributed to end users from QMC.
• Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from multiple source systems including Netezza, Oracle, DB2, SQL server, Teradata, Hive and non - relational sources like flat files and XML.
• Used Database components like tMSSQLInput,tMsSqlRow, tMsSqlOutput, tOracleOutput, tOracleInput etc and created talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Created ETL job infrastructure using Talend Open Studio and worked on the design, development and testing of Talend mappings.
• Created Talend ETL jobs to receive attachment files from pop e-mail using tPop, tFileList and tFileInputMail and then loaded data from attachments into database and achieved the files.
• Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming, naming standards and improved the performance of Talend jobs.
• Worked on Talend components like tReplace, tmap, tsort and tFilterColumn, tFilterRow, tConvertType etc.
• Worked with various File components like tFileCopy, tFileCompare, tFileExist, TFileDelete, tFileRename.
• Worked on Created triggers for a Talend job to run automatically on server. Worked on Exporting and Importing of Talend jobs.

Environment: Qlik Sense, Talend, Amazon Redshift, PostgreSQL, SQL Server, Windows 2008 R2 Server, Qlik Sense Management Console, Amazon AWS, MS Excel.

Confidential

Sr. Data Analyst

Responsibilities:

• Worked collaboratively with Business Analysts, Product owners and Data Architects to understand reporting needs and to design and build.
• Loaded the structured data (Web data and Digital Data) and Splunk logs into HDFS.
• Created analytical views in HDFS as per the reporting requirement and for cross channel analysis.
• Developed dashboards for analyzing the non-registered users who are calling the call center and drill down into the company these users work for, demographics etc.
• Built reports for analyzing the total members contacting Anthem each day, the interactions made demographics of these members over different time periods.
• Worked with over 120 million users customer data and created numerous custom charts along with basic tableau chart types. Venn diagram representing the total members and interactions for Digital Channel, Solution center and both the channels.
• Cross channel analysis to understand why registered users are calling the call center, how many members are making a digital interaction and then using solution center, drill down into the reasons for this type of interactions based on total digital interaction errors, interaction types etc.
• Design Metadata Layer for Tableau reports and Tableau metadata management with maintaining consistency in server data source.

Environment: Tableau, Hive, HDFS, Splunk, MS Excel, Python.

Confidential

Data Analyst

Responsibilities:

• As one of the youngest employees in the company to be promoted to the role of team lead, I led teams to gather business requirements, build BI applications to provide insights and provide business solutions based on discoveries made.
• Analyzed data quantitatively and qualitatively with different tools like SAS, Tableau, R Programming, Talend, Informatica and Qlik Sense.
• Collaborated with the business community and other BI team members on the definition, construction and deployment of reports, dashboards, metrics and analytic components, as well as data migration design and testing.
• Scheduled data refresh on Tableau server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately and sent those to production after editing.
• Experience in trouble shooting and performance tuning of reports and resolving issues within tableau server and reports.
• Developed many python applications for extracting data from different sources like PostgreSQL and export to formats desired by client.
• Operationalized the extracts generated from the python applications so that the extracts are automatically stored in AWS S3 and emails are sent to the respective clients based on the frequency configured.
• Built complex views to transform data for the reporting needs from various external data sources like LYNX, IHS, SFDC
• Strong experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts usingInformaticaPower Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger)
• Extensively worked on Informatica Designer Components such as Source Analyzer, Transformations Developer, Mapplet and Mapping Designer.
• Expertise in Data Cleansing at staging level with utilizationInformaticaPower Center.
• Designed and developedInformaticaMappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Worked on the design, development and testing of Informatica mappings. Created tables, stored procedures in SQL for data manipulation and retrieval, Database Modification using SQL, PL/SQL, Stored procedures, triggers, Views in Oracle.

Environment: Tableau, Qlik Sense, R Programming, Informatica, Amazon Redshift, SQL Server, Python, MS Excel.