PROFESSIONAL SUMMARY

• Business - minded data analyst wif a demonstrated ability to deliver valuable insights via data analytics and advanced data-driven methods.
• Ability to communicate and work wif cross-functional teams, navigate ambiguity, and demonstrate strong problem-solving skills.
• Over 6 years of professional experience in Information Technology including requirements gathering, application design and development, testing, deployment and maintenance support.

TECHNICAL SKILLS

• Business Intelligence (BI)
• KPI Dashboards
• Predictive Modelling
• Agile and Scrum Techniques
• ETL Implementation
• Data Mining and Visualization Tools
• Decision Analysis
• Data Integration and Stewardship
• Talend, SSIS, SSRS, Tableau
• QlikView, Qlik Sense, NPrinting
• MS Power BI, MS Power Apps
• Snowflake, C, C++, Java
• JavaScript, HTML, Python
• MS SQL, My SQL, Oracle
• SharePoint, MS Office, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential

SENIOR DATA ANALYST

Responsibilities:

• Development of financial dashboard for Corporate Accounts Receivables using QlikView, developed a Power BI model for financial reporting, automated Power Query refresh using Power shell script and windows task scheduler
• Support DOT regulatory compliance for on-road over-weight trucks and delivered results to Senior Management by analyzing data in Power BI
• Experience inimporting/exportingdata between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility wif monitoring/troubleshooting jobs between internal and 3rd party sources
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008
• Implemented Microsoft Azure SSO in different applications like GitHub, Snowflake, Talend fabric and Talend data catalog
• Used Python to extract emissions data from XML files and to forecast operational stats for upcoming months
• Used Talend to design and develop data integration job to extract, cleanse and load data from databases, warehouses, and SFTP sites to Snowflake warehouses
• Designed and implemented data model in Snowflake for human resources department extracting data from various sources including SQL and Excel.
• To improve business productivity, communicated operational performance by creating PDF, excel push reports and email distribution to business users using NPrinting, created alerts for out of spec KPI data in Power BI to business user’s emails
• Designed and implemented Data Stewards in Talend to isolate and re-direct errors to be rectified while processing remaining data
• Documented (Data Mapping, Technical Specifications, data dictionaries, etc.) for various projects

ETL DEVELOPER

Confidential

Responsibilities:

• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2005/2008).
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Worked wif Mortgage teams to identify business requirements and studied current reporting practices through pivot tables for QlikView reporting
• Delivered advanced/complex reporting solutions and standardized reporting using QlikView 11
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files and flat files using OLEDB/ODBC
• Tuned Corporate Performance Dashboards using incremental load logic (Insert, Update, Delete) to source and underlying data in QlikView
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data clean-up.
• Applied security to document (section access) and QMC server level (reduction, distribution and loop) which is their utmost requirement
• Created reports in Pixel Perfect, Excel, Word, PowerPoint using NPrinting designer and automated jobs in NPrinting Server
• Extensive experience in QlikView Scripting, Set Analysis and Section Access

QLIKVIEW DEVELOPER

Confidential

Responsibilities:

• Designed and developed executive dashboards in QlikView
• Designed and implemented star schemas in QlikView for optimization
• Created custom queries/reports designed for quality verification and information sharing
• Used Drill Down information by creating Groups/Cycles in QlikView and used Set Analysis to provide custom functionality in QlikView Applications
• Scheduled QlikView jobs in QMC and distributed to business users
• Conducted troubleshooting and fixing the QlikView dashboard issues
• Worked in database programming, SQL, Tables, Views, Indexes, Joins and Sub - Queries

JR. SOFTWARE DEVELOPER

Confidential

Responsibilities:

• Customer facing role to perform requirement analysis and deliver final requirement documents
• Developed test scenarios and implemented test plan, providing key input parameters to users to define project and system requirements
• Designed forms in Data Entry Applications using Visual Basic as front end and java in the backend and loaded data to database
• Worked on custom queries and generated Monthly Revenue Reports
• Supported design of Database tables, views, and sequences
• Worked on minor bug fixes
• Provided on-call support as necessary