Senior Programmer Analyst having 13 years of experience, including 9 years and 4 months of experience in efficiently analyzing and managing data using Informatica, SQL Server Business Intelligence - (SSIS, SSAS, SSRS), Oracle, Teradata and SQL Server Databases. Proficient in System Study, Analysis, Integration, Implementation, Performance Tuning and Problem Solving of, and using, ETLs and stored procedures. Possess in-depth understanding of SDLC, Agile Methodology, elicitation and analysis skills with excellent communication and presentation skills to share recommendations with clients. Experienced in managing the team and handling end to end phases of the project, such as requirement analysis, coding & development, unit testing, performance tuning, production deployment, support and fixes.
RDBMS: Oracle, Teradata, Microsoft SQL Server
Integration Tools: Informatica, SQL Server Integration Services
Analysis Tools: SQL Server Analysis Services
Reporting Tools: SQL Server Reporting Services
Others: Microsoft Visual Source Safe 6.0, MS Office
Supported the Business Intelligence team in performance tuning of SQL stored procedures and migration of the report dashboards from excel to SQL with SSRS. As a Senior Immigration Consultant, assisted IBM candidates in migrating to the US. Worked on L1A, L1B, L4, H1B, H4, TN, NAFTA, PERM and EAD categories. Performed analysis on files, reports, and information systems and databases to update information and maintain data integrity. Processed >200 Visa Applications in a span of one year. Advised IBM Immigration teams and Attorneys on visa options when on-boarding non-immigrant candidates. Ensured the Immigration Public Access Files are in compliance with US regulations. Assisted immigration attorneys to ensure all Request For Evidence (RFE) issued by USCIS are answered in a timely manner.
Handled the promotion of business, service, and brand of HPE Servers and Storages. Organized company conferences, trade shows, and major events. Built brand awareness and positioning. Evaluated and maintained a marketing strategy. Directed, planned and coordinated marketing efforts. Communicated the marketing plan. Developed each marketing campaign from start to finish. Researched demand for the organization's products and services.
Set goals and managed the performance of team members for Kaiser Permanente and UNUM projects. Participated in gathering and analysis of business requirements. Conducted impact analysis for existing business processes. Formulated and maintained data sources, test plans and conditions. Provided assistance during UAT and implementation reviews. Coordinated between the onsite and offshore teams in terms of work allocation, review & testing, daily & weekly status reports and organizing regular status calls. Developed ETL source to staging and staging to target mappings based on the business requirement given in the Data mapping document, to load the Professional and Medical claims data from Kaiser server to the requested targets such as Oracle, XML and flat files and send it to business users. Evaluated and documented Informatica mappings and staging tables. Managed the disability claim process, record documentation of claim communications and interactions and access imaged claim data. Integrated the data with an imaging tool to allow full on-line claim file documentation. Extracted data from various source systems like MERLIN, OPAL and CLONE and loading into staging and EDS layers. Collected data from different source (Hybrid Project) and loaded to the Teradata target tables (Staged data). Transformed the Staged data applying various business logics and kept in foundation layer tables (Integrated data). Further, transformed the integrated data again transformed to create different data marts so as to reach a point where the data which is partitioned as per the fields in order to make it easy for the end user to query the data for different departments/fields (Presentation data).
Executed development processes for the project such as build automation, unit testing, software configuration management and packaging. Worked and collaborated with Application and Domain architects in design and client development teams in development and support. Worked along with the team to develop, maintain and enhance all the in-house dashboards.
Second Runner up in Division Level International Speech contest held at Bangalore, India.
Silver medalist in Inter-Zonal Kabbadi held at Tamil Nadu, India.
Received "Most Hardworking Employee" Award twice in CSC.
Received "Best Employee Of The Quarter" Award in Hexaware.
Winner in District level Chess conducted at Tirunelveli, Tamil Nadu, India
Companies Worked For:
Job Titles Held: