Radhika Muthukumar Email & Phone Number

Norwalk, Ct, Us

Stamford, Ct

 Designed logical and physical data models SQL and created DDL scripts like tables, views, stored procedures, UDF and partitions. Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the data Created Global Variables, Stored Procedures, Triggers, User-defined Functions, partitions and Views for both Online and Batch requests handling business logic and functionality of various modules.  Migrated existing databases from SQL2008 to SQL2012 and created database snapshots from reporting purposes. Responsible for Deploying the SSIS packages into production and scheduling the package through Jobs, setting the Configuration files and created technical specs documents for all the enhancements.  Developed programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries. Implemented Event Handlers and Error Handling in SSIS packages and notification framework. Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination. Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.  Automated daily administrative tasks like database backup and recovery using SQL Server Agent  Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements. Integrated database structure and data warehouse layers to supporting web services and web applications Created Power View ad-hoc reports in SharePoint and used BI Semantic Model Connection File.

Hartford, Ct

 As a Report writer/SSRS Developer, my job responsibility is to Design, Development, Testing and support of the application systems.Responsibilities:  Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2008R2. Configured SSIS packages using Package configuration wizard to allow Packages run on different environments. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases. Coordinate with business users in gathering business requirements and translating them to technical specifications. Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS. Create Different types of reports based on customer Request. Create Sub Reports and Drill-Through Reports and developer them to share Point Server. Working on performance tuning to Test the Query Execution. Created Ad-hoc Reports, Sub Reports, Drill-Through and Drill-Down Reports. Data migration using DTS services across different databases like Oracle, MS access 2003 and Flat Files. Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance. Exposure in using Team Foundation Server as a source control, source repository and project tracking solution. Created Datasets in T-SQL, stored procedures for SSRS. Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc. Created Dashboards in SSRS 2008.

Greensboro, Nc

 Designed logical and physical data models SQL and created DDL scripts like tables, views, stored procedures, UDF and partitions. Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the data Created Global Variables, Stored Procedures, Triggers, User-defined Functions, partitions and Views for both Online and Batch requests handling business logic and functionality of various modules.  Migrated existing databases from SQL2008 to SQL2012 and created database snapshots from reporting purposes. Responsible for Deploying the SSIS packages into production and scheduling the package through Jobs, setting the Configuration files and created technical specs documents for all the enhancements.  Developed programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries. Implemented Event Handlers and Error Handling in SSIS packages and notification framework. Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination. Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks. Automated daily administrative tasks like database backup and recovery using SQL Server Agent  Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements. Integrated database structure and data warehouse layers to supporting web services and web applications

Boston, Ma

 Worked on Data migration using SSIS from Flat Files. Worked on ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load and Analyzed the Project requirement and preparing the documentation for the ETL Package Flow. Worked on ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL Job Scheduled to run daily, weekly and monthly. Solved the issues associated with ETL Data Warehouse Failure. Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like lookup, merge, merge join, script component and slowly changing dimension. Developed, monitored and deployed SSIS packages and Responsible for Scheduling Jobs, Alerting and Maintaining SSIS Packages.  Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column, Row Count etc. Designed SSIS Management Framework to monitoring, auditing and configurations and to track package failure and durations, so developer can solve issue accordingly.Implemented Data Transformation Services Packages in SQL Server Integration Services (SSIS) for transferring data and Data Loads. Interacted with the Business Users to analyze the Business process and gathered the requirements & provided documentation for all kinds of reports, DTS and SSIS packages. Wrote complex SQL queries using joins, stored procedures, and user defined functions to verify the data from the database to generate reports based on the business requirement. Utilized SSRS reports from different source formats satisfying clients by representing reports and presentations. Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports using SQL server 2005/2008 R2 reporting Services. Responsible for Monitoring and Tuning Report performance.

Hyderabad Area, India

 Developed SQL scripts to Insert, Update and Delete data in SQL database tables. Involved in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client-server environments.  Creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL). Implemented Database Replication (Merge and Transactional). Created backup schedule for production, test and development servers. Creating databases and logins with permissions in SQL Server as per the developer’s request. Created Views to enforce security and data customization. Created Stored Procedures for commonly used complex queries involving join and union of multiple tables. Created Non-Clustered indexes to improve query performance and query optimization.