SQL Server, Stored Procedures, Oracle, PostgreSQL, SSIS, Informatica

Megha Balakrishnan

Email: ************.*****@*****.***

Location: Houston TX

Cell: +1-661-***-****

Summary

Around 6 years of total IT experience and expertise in Database design, development and maintenance, Data Analysis and business Intelligence (BI) applications.

Extensive experience with various data processing platforms and languages including Oracle PL/SQL, SQL Server T-SQL, MySQL and PostgreSQL PL/pgSQL.

Experience in data analysis using Excel and Talend.

Experience in languages such as C# and Python.

Experience in Star/Snowflake schema, FACT & Dimension tables.

Proficiency in SQL across a number of dialects (we commonly write MySql, PostgreSQL, Sql Server, and Oracle)

Well versed in Normalization / De-normalization techniques for optimum performance in relational and dimensional database environments.

Experience in importing and exporting data in Oracle, Sql Server, PostgreSQL and MySQL.

Experience with requirements gathering, creating Data Mapping, documents, writing functional specifications, queries.

Experience in setting up connections to different RDBMS Databases like Oracle, SQL Server, DB2, Teradata according to user requirements.

Expertise in working with ETLs such as SSIS and Informatica.

Experienced in working on Agile methodology.

Experienced in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources to various databases using SSIS and Informatica using various features like data conversion etc. and well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.

Experienced in creating Sql Jobs for scheduling SSIS tasks.

Strong experience in Data Migration, Transformation, Integration, Data import and Data Export.

Understanding of principles of fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.

Expertise in working with BIRT and SSRS reporting tools.

Experienced in writing and creating complex SQL queries, Indexes, Views, Temporary tables, Triggers, Tablespaces etc.

Experience in using OEM and Snapshots for analyzing queries.

Experienced in working with Veridata Tool to find the data mismatch.

Experience in using JIRA for creating and tracking requests, also in creating Kanban boards for tracking the JIRA tickets.

Experience in working with Excel Pivot and VBA macros for various scenarios.

Education

B.Tech in Computer Science, University of Calicut, Kerala, India. (Year : 2005 to 2009,Course Type : Regular)

Technical Skills

Cloud Platform: AWS, EC2, RDS

Reporting Tools: BIRT Reporting, SSRS

Programming Languages: SQL, PL/SQL, T-SQL, PL/PgSQL, Python

Databases: Oracle 12c/11g, PostgreSQL 9.2/9.4, MS Sql Server 2016/2014, MySQL.

Data Comparison Tools: Veridata Tool

Version Controlling Tool: SVN Tortoise, GIT

Issue Tracking Tool: JIRA

Operating System: Windows, Linux

ETLs: Informatica, SSIS.

Programming Languages: C#.Net,Python

Methodologies: Scrum, Kanban, System Development Life Cycle (SDLC).

Visualization Platform: Power BI,Excel

Work Experience

Thomson Reuters May 2017 – June 2018

Location: India

Client Location:USA

Role: Sr. Database Developer

Responsibilities:

Worked as Senior Database Developer to review business requirement and create/update functions in databases to achieve the functionalities.

As per client’s requirement, created functional specification documents used for Data Creation

Used Agile Methodology of Data Warehouse development using Kanbanize.

Conducted POCs (Proof of Concepts) for Oracle Dataguard setup in Linux to reduce the data mismatch between HA servers.

Established

Involved in doing Sql Mirroring.

Installed and upgraded the databases such as Oracle, SQL, PostgreSQL and MySQL in Windows and Linux Servers.

Improved SQL performance through index development, query tuning, managing table spaces, resource distribution, system analysis and other system performance metrics.

Developed and implemented data cleansing, data security, data profiling and data monitoring processes.

Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL

Worked on Salesforce to analyze the requirements of the customers.

Worked on ServiceNow to raise requirements and worked with the team to analyze and fix the issues.

Performed monitoring and optimizing the performance of the database using OEM and by using performance charts.

Worked on database design, relational integrity constraints and Normalization (3NF) & De-normalization of database.

Extensively used Veridata tool to compare data mismatch in different environments.

Worked closely with DevOps team for making 100% application uptime.

Extensively developing and tuning Stored Procedures, Triggers, Packages and Functions in PL/SQL, PL/pgSQL and T-SQL for applications.

Created Kanban dashboards in JIRA using JQL queries.

Knowledge in creating data objects in databases such as Oracle and PostgreSQL.

Develops and supports database architecture and development to create and enhance the Enterprise Applications.

Conducted POC for using multiple user login to the application which avoids application downtime.

Performed ad-hoc analyses, as needed, with the ability to comprehend analysis as needed.

Migrated database from Oracle 11g to PostgreSQL 9.4 using migration tool (EDB Postgres) to make the application work on PostgreSQL database.

Extensive experience in creating Packages in Oracle and PostgreSQL.

Done python coding for transferring details from browser to flat files to avoid the frequent login to the site for fetching the details, which integrated with data Vault.

Technology/Tools: Toad, Sql Developer, MySQL, PostgreSQL 9.4, Oracle10/11g/12c, Sql Server 2012/2014, Enterprise Postgres, OEM, Veridata Tool, SVN Tortoise, Git, Python, pgAdmin, AWS EC2,RDS,Python,Power BI

Infosys Pvt Ltd Aug 2015– May 2017

Location: India

Client Location: USA

Role: Technology Analyst/ Database developer

Responsibilities:

Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

Performed data analysis using complex SQL on various sources systems including Oracle 10g/11g and SqlServer 2008/2012.

Responsible for researching data quality issues (inaccuracies in data), worked with business owners/stakeholders to assess business and risk impact, provided solution to business owners.

Extensive experience in data warehousing ETL tools like SSIS and Informatica.

Worked on creation of SQL Jobs to schedules jobs and handles other automated tasks.

Extensive experience in developing, enhancing and optimizing stored procedures, functions and triggers with Transaction-SQL (T-SQL) on Microsoft SQL Server 2012 and PL/SQL Oracle.

Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

Extensive experience on table structuring.

Performed data modeling and data analysis as required.

Worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data model.

Worked with the Data Architect in defining and maintaining database design standards.

Successfully delivered many new functionalities.

Collaborated with other data modeling team members to ensure design consistency and integrity

Developed, maintained, and applied standards for enterprise modeling, including reviews, naming conventions and XML naming standards

Worked in SQL performance tuning, query tuning and code reviews.

Done the query optimization and reduced the execution time of long running queries from hours to seconds.

Created and converted reports from Crystal reports to BIRT reports.

Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.

Created DML code and statements for underlying & impacting databases.

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using SSIS and Informatica.

Worked with the team to fix/maintain production data.

Used Analytical functions like RANK, ROW_NUMBER etc.

Technology/Tools: Toad, Sql Developer, Oracle 10/11g, Sql Server 2008/2012, Query Optimizer, BIRT Reporting Tool, JIRA, ETL Tools -Microsoft SSIS, Informatica PowerCenter,Excel

PointCross.com Pvt. Ltd Dec 2011− Nov 2014

Location: India

Client Location:USA

Role: Software Engineer

Responsibilities:

One of the core developers who took part in building the solution out for Ipsen (Health Care) since the beginning.

Analyzed packages, procedures and functions and optimized the existing code if it required by evaluating the execution plan.

Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.

Followed the development process in SCRUM methodology.

Worked along with the team in building the solution on top of a new data tore built on top of PostgreSQL.

Manually converted the procedures written in Oracle & SQL Server to PostgreSQL, also written new functionalities in Oracle, Sql server and PostgreSQL.

Efforts include exporting & importing databases from the test environment to UAT environment using pgAdmin.

Converted the Oracle schema to PostgreSQL schema both manually & using EMS tool.

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Worked in importing and cleansing of data from various sources like N Oracle, flat files, SQL Server 2008 with high volume data

Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.

Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)

Worked on C#.NET REST Web Service calls to communicate with the back end engine.

Followed company code standardization rule

Used Analytical functions like RANK, ROW_NUMBER etc.

Extensive knowledge on PostgreSQL configuration file set up such as postgresql.conf, pg_hba files etc.

Involved in development efforts around middle tier to change the dynamic link library (DLL) built on C#.NET which was imminent for its functioning in windows and Linux Servers.

Involved in writing new procedures as well as converting the existing procedures into PostgreSQL database.

Experience in creation of Database, Tablespace and Segments to distribute the database objects.

Provide support to client with assessing how many virtual user licenses would be needed for performance testing.

Experience knowledge about monitoring and optimizing the performance of the database.

Experience in working with xml functions such as XMLELEMENT, XMLATTRIBUTE, XMLAGG, XMLPARSE etc.

Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Worked on VBA Macros.

Experience in writing hive queries.

Technology/Tools: PostgreSQL 9.2, Oracle 10g, SQL Server 2008, Microsoft Visual Studio, Excel VBA, PgAdmin, EMS Tool, SVN Tortoise, Hive,C#.Net.

Contact this candidate