Pramila

Plot No 177, Door No 5, 7th Cross Street, Vysarpadi, Chennai – 600 039 Pramila Vimal Raj Tel:- Email:- SUMMARY             Results-driven Database Developer and Microsoft BI Developer with experience in back-end programming, relational databases and development/maintenance of ETL Solution using Microsoft technologies. Have excellent leadership and communication skills, Positive Attitude and a good team player. Designed end to end data warehousing projects with layers like Sourcing, staging and datamarts. Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Have been part of successful migration from SAS to AWS Redshift. Having extensive knowledge on AWS Redshift functions and Limitations. Have also single migrated few databases from Oracle to MariaDB Also involved in migration of statistical models from SAS to SQL Good experience in Data warehouse concepts and have extensive hands on SSIS and SSAS cubes. Highly skilled Developer with vast knowledge in following technologies like AWS Redshift functions and limitations, Oracle SQL, PL/SQL, SQL Server (T SQL &Stored Procedures), SQL Server Analysis Services(SSAS), SQL Server Integration Services(SSIS), Peoplecode and Basic Java PeopleSoft CRM, Sales Incentive Management, Sales and Marketing. Obtained OCA (Oracle Certified Associate) from Oracle Corporation with aggregate of 97% Have taken training for new entries to organization conducted by Cognizant Technology Solutions, India on various topics like Java, SQL, Problem Solving skills etc., EDUCATIONAL QUALIFICATION    B.Tech in Information Technology(86.6%), Madras University (2000 to 2004), India XII – (92.25%), from S. S. Girls Higher Secondary School (2000), India. X – (93.4%), from S. S. Girls Higher Secondary School (1998), India. Data Warehousing Tools that I worked with Relational Database: Oracle 10g/11g.SQL Server 2008, 2010, 2012, MariaDB Columnar Database: Amazon’s Redshift Language: Advanced SQL, PL/SQL ETL Tools: SSIS Data modeling tools: SSAS, Basic SAS PROFESSIONAL EXPERIENCE Employer : Jigyasaa Analytics. a. Project/Module: Modeling and Scoring Role : BI Developer    Duration: July 2016 – Present Client : Hearst, US Have developed a ETL Solution in SSIS that imports more than 200 millions rows into SQL Server ETL package was also enhanced to create partitions, indexes etc., Have been involved in the transformation of above data to various formats for different business needs   Involved in identifying bottlenecks in ETL data pipeline. Fix their performance issues Develop jobs to extract data from various sources, apply transformations and business rules on the relevant data to load to Exposure Source Data Base 1. Employer : Jigyasaa Analytics. b. Project/Module: Migration Project Duration: July 2015 – June 2016 Role : Team Developer/Tester/Lead Client : Hearst, US          This is a work from home assignment was asked to study existing statistical models on SAS and convert them to AWS Redshift SQL and SQL Server 2008. Analyzed and explored options of moving from Oracle relational DB to MariaDB. Justification Documents were prepared for the same. Exported data from Sybase to SQL server. Have excellent experience on creating LinkedServer, Creating DSN, ODBC connections etc Also involved in converting few procedures from Oracle PL-SQL to AWS Redshift. In the process, got extensive hands on SQL Server Management studio tools, T SQL, AWS Redshift functions and limitations. Imported and exported data regularly in both AWS Redshift and SQL Server 2008 Prepared test data, created test plans, executed test cases. Have prepared various analysis and test case documents, Project Plan etc., c. Project/Module: MSBI Developer Duration: Apr 2014 – July 2015 Role : Team Developer/Tester/Lead Client : Hearst, US        This is a work from home assignment was asked to study existing system and worked on SSAS, SSIS cube and corresponding enhancements. Learnt SSAS, SSIS on the go and in the process I learnt basics of Data warehousing like star schema, snowflake schema, facts, Dimensions, aggregations etc., Studied the existing Data warehousing and developed few enhancements very quickly Got extensive hands on SQL Server Management studio tools and T SQL. Designed and developed various PIVOT Reports connecting to cubes. Have prepared various analysis and test case documents, Project Plan etc., Providing support and fixing production issues of the cube till date. d. Project/Module: PL/SQL Procedure Developer Role : Team Developer/Tester/Lead    Duration: Mar 2014 - Apr 2014 Client : Hearst, US This is a work from home assignment was involved in the development of stored procedures in ORACLE, after a sabbatical but my lead never felt that I came from a break. Worked on various PLSQL concepts like encryption, JOB creation, Dynamic stored procedures etc., Also code reviewed and tested the stored procedures of other team members. 2. Employer : Spcits a. Project/Module: Business Development Associate Role : Business Development Associate Jan 2014- Mar 2014 Duration: Jan 2014- Mar 2014 Client : NA Spcits is basically a web designing and development company.  Was involved in directly with the client to get business for the company.  Was also responsible for all the initial interaction between client and the company  Used various digital marketing strategies like email campaigning, cold calling etc., 3. Employer : Cognizant Technology Solutions. Aug 2004- July 2008 a. Project/Module: Customer Compass CRM/ Sales Incentive Management Duration: Oct 2007- July 2008 Role : Team Lead/Developer Client : Cognizant Sales Incentive Management (SIM) was developed to automatically calculate commission of sales agent which involved various complex logic.  Was leading a team of four with no major issues for almost a year  Have excellent functional knowledge on PeopleSoft Sales and Marketing Module, CRM Module  Was involved in requirements gathering, Analysis, Design, Development, testing of various complex requirements and also provided Production Support for end users.  Have successfully conducted couple of audit for the SIM Team.  Was involved in various process like impact analysis, auditing, Estimation etc.,  Have prepared multiple reports for users which involved writing complex excel macros.  Have played multiple roles as Developer, Tester and Team Lead as required Have interacted with high end users and actively participated in all calls. b. Project/Module: Customer Compass CRM Duration: Apr 2007- Aug 2004 Role : Team Lead/Developer Client : Cognizant  Was the only Developer in Offshore to complete the entire Analysis, Design and unit testing of the Customer Satisfaction Survey Requirement (CSS) and the Phase I has been successfully moved to production.  During the development gained excellent technical knowledge on Configurable Searches, CDM classes, Rowsets etc.,  Apart from CSS, coordinated with EPM Team as a single member from CRM side to generate various reports.  Played a dynamic Role sometimes helping the testing team and other junior developers learn People code  Have also taken training on ANSI – SQL and People soft Application Engine at the organization level training conducted by Cognizant for the fresher’s. c. Project/Module: TRANE PeopleSoft CRM Engagement Duration: Aug 2006- Apr 2007 Role : Team Lead/Defect Fixing Team Client : Trane, US    One of the main developer for fixing the defects and has always ensured to fix the defect within the given SLA and in the process has thorough knowledge on PeopleCode, PeopleSoft Application Designer and Component Interface. Was also one of the core Developer in MGH Integration with excellent knowledge in Application Engine, Component Interfaces, CDM Classes etc., Have also been handling the various project managements tasks like preparing estimates for various new requirements, project planning, collecting metrics and maintaining the same for the entire project. d. Project/Module: JPMC-CSX/CSX Reporter Role : Team Lead QA Testing     Duration Client : Feb 2006 – Aug 2006 : JP Morgan Chase, US Led the QA Team successfully for minor release and a major upgrade activity. Participated in the development of test-scripts, testing the Reports, preparation of testing queries, timelining and estimating job allocation. Shouldered the responsibility of representing the offshore QA Activity to the Client everyday Prepared various documents like Test Plan, Defect Excels and used the Test Director tool for logging various the QA Defects. e. Project/Module: JPMC-CSX/SQL To Oracle Migration Role : Technical Analyst/ Developer     Was part of successful delivery of 106 Oracle Stored Procedures developed in PL/SQL which were migrated from SQL Involved in all phases of Design, Development and unit testing of the migration process Gained a lot of technical expertise on both SQL and PL/SQL programming. Also represented the Team for Quality Audits. f. Project/Module: JPMC CSX/Configuration Role : Technical Analyst/ Configurator      Duration : Sep 2005 – Feb 2006 Client : JP Morgan Chase, US Duration : Mar 2005 – Sep 2005 Client : JP Morgan Chase, US Received an Appreciation Award from Cognizant Technology Solutions for Outstanding performance in Configuration Involved in Configuring Peoplesoft Application for various requests like User Setup, Controlling their accesses, Setting up their Provider Groups etc., Debugged existing WinRunner scripts as well as developed a few scripts on-the-fly. Was also responsible for writing SQL scripts for testing. Handled the Product Data Configuration. No bug has been reported till date and was also appreciated by the client for completing certain emergency requests well before time. Collected and monitored metrics related to productivity and quality. g. Project/Module: Health Care Facets/ HSB Claim Conversion Duration : Aug 2004 – Mar 2005 Role : Systems Analyst/Developer Client : Central Benefits Central Benefit is a US based health insurance company which makes use of Facets database to record various activities like claims, benefits etc.,    Was responsible for the entire module and all its aspects, like test case preparation, coding, interacting with onsite coordinators for clarifications and unit-testing to ensure strict adherence to quality and metrics. During the process gained lot of knowledge on Health Care Domain, and even undertook a Cognizant-level Certification Exam. Module was successfully delivered on time.