A position in Software Professional providing opportunity to make a strong contribution to Organizational Goals through continued development of professional skills.
Total 9+ years exp, in dat around 6+ years of experience in development of Data warehousing solutions using Informatica 9.1/8.x/ 7.x and Qlikview 8.20/9.0.
Knowledge of different Schemas ( Star, Snow Flake and Extended Star Schemas) for query and business analysis requirements
Extensive working experience in Data Warehousing technologies and client/server applications in Healthcare/Finance/Retail Domain.
Has worked on different phases of project development life cycle. Has done: Analysis of requirements, Creation of sub - project estimates, Creation of work order, Creation of detail design document, Coding, Unit testing & Integration testing.
Involved in Design, Development, and testing phases of Data warehousing projects.
Created complex mappings using Lookup, Joiner, Aggregator, Stored procedure transformations.
Good understanding in Change Data Capture (CDC) techniques like slowly changing dimensions, slowly growing target, and simple pass through.
Possess excellent communication and interpersonal skills and ability to work in a team as well as individually.
ETL: Informatica power centre 9.1/8.x/7.x
DBMS / RDBMS: Oracle 9i/10g, Sybase
Programming Languages: PL/SQL, Unix Scripting
Tools: SQL*Plus, DBArtician
OLAP: Business Object
Alanlytical Tool: Qlikview 8.20/9.0
DWH / BI Consultant
Designed and developed Claims and pharmacy data mart ETLs
Provided performance improvement and system stability solutions.
Analyzing and evaluating new changes as per production system guidelines as well as providing approvals for deployment.
Analysis, development and implementation of system enhancement, bug fixes etc.
Proactive monitoring and analysis of production system statistics; to ensure system availability and continuity in coordination wif system administrators and DBAs.
Performed problem assessment and solution analysis of business and application requirements.
Analyzed technology solutions and designed and developed in coordination wif Datacenter.
Designed data sharing and security for reporting applications.
Designed and developed ETL and reporting solution utilizing Informatica, Shell Script, Perl Scripts and Qlikview intelligence reports.
Documented system specifications and conducted walk through sessions for Data Centers.
Performed requirement analysis and research in coordination wif Business users, Business analysts and system analysts.
Designed integration process wif IBD database and enterprise wide data feeds (flat files and XMLs) from various applications.
Defined development, deployment and support best practices as per enterprise guidelines.
Managed wif ETL deliverables and coordinated wif project leads on project timelines and software delivery plan.
Conducted cost estimation, role based task allocation and gap analysis.
Documented system specifications and conducted walk through sessions for stakeholders.
DWH / BI Consultant
Redesigned existing ETL process to improve total runtime and maintainability.
Migrated 7 Informatica ETL applications from 7.x version to 8.x wifout impacting upstream and downstream system in 3 months, only.
Designed and developed business intelligence reports using Microsoft SQL Server; as well as optimizing multidimensional data retrieval.
Documented system specifications and conducted walk through sessions for business users.
Educated business user on new applications/platforms for analysis and reporting.
Trained new team member on functional as well as technical aspects of project as well as managed their task allocations.
Technical Support Executive
I was associated wif Aetna Healthcare, are responsible for processing the claims to accurate payment to the provider based on service agreement and diagnosis.