PROFESSIONAL SUMMARY:

• 5 years of IT experience in the field of Data Science & analysis, SQL business intelligence development, ETL Development, Data Modelling, and Data Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data governance, Master Data Management and Configuration Management.
• Experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• 3+ years of hands on experience in TSQL/SQL, SAS, Python, Excel.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, SAS, Tableau, and Power BI.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 8.0 and 8.1 as an Analyst.
• Knowledge on Azure data factory, Azure data lake, Cosmos.
• Working knowledge on Confidential business intelligence stack: SSIS, SSAS and SSRS.
• Experience in Working with different industries like private banking, financials, retails.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Experience in creating functional/technical specifications, data design documents based on the requirements.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS:

Programming: C++, Java, Python, TSQL, PL/SQL, SAS, R

Confidential office tools: Excel, PowerPoint, Access, Visio, Outlook

Data analysis tools: SAS, Excel, Tableau, TSQL, R, Power BI

RDBMS: MySQL, MS SQLSERVER 2012/2013/2014 , Oracle 10gFoxPro, DB2

Operating systems: Windows, UNIX, Mac

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer, Redmond, WA

Responsibilities:

• Designed C# based scope scripts to acquire data from multiple sources viz. Cosmos, SQL, Blob.
• Designed SSIS package and re modified the existing package, benefited the team to bring down the overall process to run within 4 days (earlier was 1 month).
• Deployed and designed pipelines through Azure data factory and debugged the process for errors.
• Extensively worked on Visual studio 2012/13/14 (enterprise and ultimate versions) to analyze SQL server packages and implement recommendations.

Environment: Visual Studio 2013/14/15 Enterprise/Ultimate, MS SQL server management studio 2012/13/14, MS Office 2013, MS Visio 2013, Azure Data Factory, Azure Data lake, Cosmos, Power BI, MS Excel, PowerPoint, MS Project, MS Outlook.

Confidential, Jacksonville, FL

Data Analyst

Responsibilities:

• Performed data manipulation, data cleansing and data profiling in the source systems that are required for Dual credit report Data mart.
• Performed statistical analysis using SQL, SAS, R, Python, and Excel.
• Experience with high performance data processing.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Created import job, workbook and export job into DataMeer.
• Define the list codes and code conversions between the source systems and MDR and also defining the trumping rules applied by Master Data Repository.
• Liaising with end-users and 3rd party suppliers.
• Analyzing raw data, drawing conclusions & developing recommendations also writing SQL scripts to manipulate data for data loads and extracts.
• Applied Master Data Management standards in data conversion, mapping and migration.
• Performing daily system checks, Data entry, and data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
• Involved in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Embarcadero.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document data quality and traceability documents for each source interface
• Experience with Mainframe enterprise billing systems.
• Worked with internal architects and, assisting in the development of current and target state data architectures.
• Used data analysis techniques to validate business rules and identify low quality for missing data in the existing Data Mart.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment: SQL/Server, Java, Python, Oracle 10g, MS-Office, MS BI Stack ETL, Hadoop, Informatica IDQ, MDM

Confidential, Buffalo, NY

Sr. Data Analyst

Responsibilities:

• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Confidential ’s employees).
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stakeholders.
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Created dashboards for ad-hoc reporting and analysis.
• Extensively involved in filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document.
• Perform small enhancements (data cleansing/data quality).
• Worked on daily basis with the mainframe team and lead data warehouse developers to evaluate impact on current implementation.
• Communicated with the third party vendor to do the programming.
• Upgraded the present application by adding new functionalities.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.

Environment: MS Office 2007, MS Visio 2003, Windows XP, MS Excel, PowerPoint, MS Project, UML, MS SQL Server, Erwin, Business Objects, MS Outlook.