Geetha Devaraj Email & Phone Number

London, United Kingdom

• Responsibilities:
• Used Ralph Kimball’s data warehouse methodologies (Star schema, Snow Flake schema, Conformed Dimensions and Dimensional Modelling).
• Designed SQL Database, tables, functions, views, stored procedures,constraints and created Sql agent jobs for daily data refresh.Designed database,schema,tables,functions,views and sequences using Postgresql.
• More than100 Dashboards/Reports designed and delivered to client.
• Migrated databases and data from Lexis Nexis to AWS.Created automation scripts to compare schema and xml's.
• Created technical design documentation.

London, United Kingdom

• Developed Multi-dimensional Objects (Cubes, Dimensions) using (SSAS). Written MDX Query to retrieve data within a cube and also used calculated member within a cube.
• Designed Dimensional modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling, Created Time Dimensions on OLAP Cubes using SSAS.
• Developed SSIS packages using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, Send Mail Task, DB check integrity task, CDC, Maintenance and For/for each loop tasks.
• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split and Execute SQL task.
• Developed SSIS package using Sequence container, For each container and For loop container.
• Loaded Initial load, Incremental load and daily load using SQL Agent job.

Monument Station, London

• Designed and developed full-scale reporting solutions for a multi-client environment using MS SQL Server SSRS, SSIS & SSAS. Translating the requirements to technical specs and converting them to Reports & Packages.
• Created, implemented and maintained a reporting suite of over 33 standard reports using SSRS and Developed complex reporting solutions,Interactive graphs were built.
• Developed various operational Adhoc, Drill-through and Drill-down reports using SSRS
• Developed complex financial reports using Sub Reports, Charts, Matrix reports, Linked reports.
• Created Dashboards for financial sector using benchmark data to provide an analytical snapshot of point in time
• Assembled and converted user requirements from multiple clients into our standard reporting solution

Bank Station, London

• Experienced to replace the Existing warehouse to Current warehouse. Based on the client requirements developed new ETL packages and deployed.
• Handled Solvency II reporting solutions project. Designed ETL Packages for Solvency II and delivered Reports as per their requirement.
• Developed SSIS packages using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, Send Mail Task, DB check integrity task, CDC, Maintenance and For/for each loop tasks.
• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split and Execute SQL task.
• Developed SSIS package using Sequence container, For each container and For loop container.
• Deployed the ETL packages to SSIS catalog and created SQL Agent job.

Canary Wharf, London

• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Performed Performance tuning on their existing packages and created the new packages based on their requirement.
• Performance Tuning Highlights: Extracted the data in parallel which will help to reduce the overall ETL execution time. Extracted the required data from table or file. Used synchronous transformations and avoided.
• Developed SSIS packages using control flow tasks such as like Bulk insert, Expression Task, File system task, FTP task, Script task, DB check integrity task, CDC, Maintenance, For/for each loop tasks.
• Created various transformations like Data conversions, Lookup, OLEDB command, Derived columns, Sort, Merge, Aggregate, Fuzzy lookup, Conditional split, SQL task, Send Mail task etc...
• Used Sequence container and For each container to most of the packages.

Rainham Essex

• Responsible for gathering requirements, understanding the business specs, preparing technical Specs, converting to SSIS Packages.
• Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.
• Developed various packages using AGGREGATE, MERGE JOIN, PIVOT, DERIVED COLUMN, DATA CONVERSION, LOOKUP, MERGE, SORT, MULTICAST, UNION, CONDITIONAL SPLIT, SCD (Slowly Changing Dimension).
• Created Event Handlers to Handling Errors and Debugging for the Packages.
• Creating jobs for scheduling the SSIS packages.
• Generated reports using SSRS report builder/manager.

River Bank House, London

• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experienced Stored procedures / User defined functions and performance tuning.
• Actively involved in development, deployment and maintenance of SSIS packages, SSRS reports and SSAS cubes.
• Involved on data migration from legacy systems to new SQL database.
• Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.
• Created packages using the data flow transformations such as like UNPIVOT, PIVOT, DERIVED COLUMN, DATA CONVERSION, LOOKUP, MERGE, SORT, MULTICAST, UNION, CONDITIONAL SPLIT, SCD (Slowly Changing Dimension).

Master Of Computer Applications (Mca), Computer Science, A

Master Of Computer Applications (M.C.A.), Computer Science