Summary

• Experienced Business/Data Analyst, with expertise in Data Analysis, Business Intelligence Solutions, Data Quality Analysis, Data Profiling, Database development, Data Integration. Experience working with a variety of complex data from domains such as Finance, Banking, Anti Money Laundering, Logistics, Risk Management, digital marketing etc.
• Experience in Business Intelligence, ETL development, dashboard reporting solutions, star and snowflake schemas, LDM design and application integration. Highly experienced in various aspects of Enterprise Data Management EDM , Data Cleansing and Data Profiling. Experienced in migration and conversion of data to/from various data sources.
• Strong experience in the Anti-Money Laundering domain, well versed with AML regulations and regulatory procedures. Highly experienced in all aspects of Know your customer KYC , Customer Due Diligence, Behavior Detection. Well versed with Sanction Screening and Transaction Monitoring process and List Management of suspects.
• Experience in database design, logical and physical modelling, writing stored procedures, triggers, views, functions in Oracle, Sybase ASE, MS SQL Server, IBM Db2 MySQL, SQL, T-SQL and PL/SQL. Highly skilled in database Performance Tuning and Optimization Techniques.
• Extensive experience including applications development, operations and technical support. Software Development Life Cycle SDLC experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities. An effective communicator with exceptional relationship management skills.
• Experience in finance, banking, market research, Anti Money Laundering, Risk Management Assessment, Payment Processing Gateway, logistics, digital marketing domains.

TECHNICAL SKILLS

• Databases: Sybase ASE 11.5/12.x/15.x, Oracle 10g/11g, MS SQL Server 2005/2008/2012, MS Access, IBM DB2, Mainframe, IMS, My SQL
• BI Tools: SQL Server Integration Services SSIS , SSRS, SSAS, DQS, Informatica, Qlikview, DataFlux, Trillium, OEDQ, Business Objects, Crystal Reports, Omniscope
• Tools: Embarcadero DB Artisan, Rapid SQL, Toad, Autosys, Control M, Remedy, Visual Source Safe, Clearcase, Sybase Open Client, SQL Loader, SQL Plus, Crystal Reports, Gupta SQL, Mantas, Actimize, Erwin, ER Studio, Power Designer, Winrunner, Power Builder, Oracle Forms Reports, MS Office, MS Project, Visio
• Operating Systems: Windows 95/98/NT/2000/XP/VISTA, MS DOS, Mac OS X, UNIX, HP-UX 10.2, Sun Solaris.
• Languages: SQL, PL/SQL, TSQL, Transact SQL, C, XML, SAS, VB Script, Visual Basic 6.0, Unix Shell Scripts, PERL, ASP.NET, J2EE, JSP, Servlet.
• Web Languages: HTML, XUL

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst/ Developer

Environment- Sybase 15.x, Oracle 11g, SQL, T-SQL, PL/SQL, Toad, DB Artisan, SAS, Business Objects, Dataflux, SQL Server 2012, SSIS, MS Access, Excel, Macros, VBA, VB.NET, Sharepoint, Gupta SQL, C, Autosys, Unix, Shell Script, J2EE

Responsibilities --

• Involved in development and enhancements to the key Loans and Securities lending application to improve the overall performance of the system and help in onboarding of new clients onto the lending system.
• Involved in various development and analytical initiatives, related to the project Fusion which will merge the SecLending and OpenLend application to provide a single portal for Loans and Securities Lending operations.
• Analyze the business requirements, analyze and document the functional work flow of data and information from source systems to destination systems.
• Conduct review of the database objects such as tables, views etc. to determine the status as-is and to determine scope of improvement in the overall design from the performance point of view and provide recommendations.
• Develop and update various stored procedures, functions, triggers, rules, defaults, user defined datatype, indexes etc., and complex SQL scripts, as part of enhancement efforts, in order to insert, load and validate the data into the appropriate tables.
• Development and maintenance of various SQL and job scripts, in order to accomplish processing of data and facilitate complex transactional and reporting functionalities and format the data conditionally.
• Performance tuning and optimization of SQL scripts, stored procedures, to improve performance slowed down considerably owing to the complexity of system and data volume increase in the last few years.
• Troubleshooting of performance issues, to help quickly pinpoint the source of the bottlenecks and implement an efficient solution. Resolve data contention, deadlocks and many other performance related issues.
• Conduct analysis of jobs, indexes clustered and non-clustered to modify, reorganize or recreate them if necessary to improve performance and tune the process.
• Create new tables and DDLs for new database objects. Write SQL queries and scripts to perform analysis of historical data as well as to reverse the settlement discrepancies.
• Data profiling and data quality review of the existing data and data coming in from the other businesses in order to assess the overall standard of the data and publish the results on SharePoint for everyone's consumption
• Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the mappings. Identify and document the source to target mapping data lineage.
• Discussions with the key stakeholders and users about the data quality and profiling results, get recommendations about specific data quality checks and provide suggestions. Conduct data cleansing and scrubbing for further loads.
• Creation of multiple reports to display the data for various lenders, borrowers and loans for varying time periods and parameters in SSRS, excel, crystal reports etc.
• Monitoring and maintenance of multiple automated data extraction jobs and daily jobs, which get feeds from various locations 24x7. Involved in resolving day-to-day issues and worked with the users and team towards resolution of issues.
• Undertake review of existing clients within the database to ensure that their documentation was kept up-to-date and that they meet the KYC and CDD check standards, in accordance with compliance.
• Development and update of the Function specification and Technical specification documents in accordance with the latest business requirements and enhancements.
• Created multiple design and enhancement documents for the changes and guided the SIT and UAT teams in testing the full functionalities and nuances of the changes.
• Coordinate and manage the development, testing and support activities between the onshore and offshore teams and ensured proper communication in order to facilitate smooth operation and resolution of issues.

Confidential

Senior Data Analyst/Business Analyst

Environment-- Oracle 11g, DB2, PL/SQL, Oracle Enterprise Data Quality OEDQ , T-SQL, Mainframe, DataFlux, Toad, Oracle Customer Data Hub, Sybase 15.x, J2EE, WinSCP, Putty, ER Studio, Unix Shell Script, Linux, Unix, Informatica

Responsibilities --

• Development and support of the key data integration and migration initiative for the conversion, integration and migration of data from different legacy systems to the central database system, from where it will be consumed for further business decisions.
• Interact with legacy business users to understand business process flow, business logics and to assess major data objects, data volume and level of effort required for data conversion and migration.
• Work with business users/owners to gather data migration requirements, design data mapping documents, and define business rules for cleansing, and transformation requirements.
• Documentation and update of the business requirements in close coordination with data stewards and key stakeholders about the ongoing approach and mapping of the objects and data elements across the systems.
• Conducted in depth CRUD analysis of the data from multiple systems, to determine the high- impact database objects, tables and to determine the data flow and potential area of improvements.
• Conduct in-depth Data Profiling and Data Quality Assessment of the data in the Legacy Systems, to determine the current level of data accuracy, conformation to standards etc.
• Analysis and comparison of the data across different sectors to check for data consistency, accuracy and relevance of the existing data. Data profiling on data for reference, waybill and shipping data and document the discrepancies observed in the data.
• Write multiple SQL and PL/SQL scripts, stored procedures etc. to process and standardize the data and conduct checks across different databases to determine referential integrity and consistency of data.
• Discussions with data architects, business stakeholders about the data quality results and have discussions about the data standards, and the kind of business rules to ensure efficient data quality standard in future.
• Develop framework to extract and dump the data from various legacy sources into the staging area and create scripts and setup to extract, parse, cleanse and massage the data to standardize it.
• Creation of the data structure and staging area for dumping the legacy data and inter-linking all the segment data for in-depth analysis and closer look.
• Creation of extraction files from various data sources, dump it into a staging area and use the script to parse data out of the files and dump it into the staging tables.
• Develop scripts, matching rules and transformations to compare data across systems and harmonize and massage the data to do cleansing and identity and eliminates the duplicates.
• Conduct migration and integration the data from multiple data sources, into the target tables using the extract, transform and load packages.
• Conduct post migration check and acceptance testing for validating the quality, accuracy and consistency of the data in the target database

Confidential

Senior Data Analyst

Project -- Annalect is a solutions provider that creates Technology solutions that allow organizations to connect their disparate data sources, and make sense of the large volumes of fragmented and unstructured marketing data, enabling them to make critical business and marketing decisions.

Environment- MS SQL Server 2008 R2/2012, T-SQL, SSIS, SSRS, SSAS, Qlikview, Omniscope, DataFlux, SSIS DQS, Oracle 11g, Crystal Reports, MS Access, Excel, VBA, .NET, Sharepoint, Business Objects, XML, Erwin, TFS, Good Data

Responsibilities --

• Development, support and maintenance of key Business Intelligence and data reporting solutions by using digital marketing and demographical data provided by the clients, enabling them to make better business decisions for future purposes.
• Implementation and delivery of business solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards in the area of digital, social media and competitive data from Google Analytics and Adobe.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments Development and Production .
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, interaction with Business Analysts, Client team, Development team etc.
• Development and implementation SSIS packages to extract and load data from various heterogeneous data sources like Excel, CSV, Oracle, MS Access, SQL Server, flat files etc.
• Data quality analysis and Data profiling of the various data sources to determine adherence to standards. Perform data scrubbing, cleansing and standardization to prep data prior to the load.
• Development and deployment of SSIS packages with tasks and transformations like Execute SQL, Execute Package, Conditional split, Script Component, Multicast, Merge and Lookup to load the data into Destination.
• Use SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Creation of SQL scripts and T-SQL stored procedures, functions, Views and other database objects for populating and validating the data. Performance tuning of various scripts, procedures, indexes etc. to improve the overall speed.
• Interaction with the development teams and business analysts to create and modify the data model and LDM Logical Data Model for publishing multiple dashboard reports on web and cloud platform in accordance with expectation of the clients.
• Development of complex, intuitive dashboard reports for the display of key business data on the platforms such as SSAS, Qlikview, Crystal reports and GoodData.
• Development of various types of complex reports like Drill Down, Drill through, Cross tab reports. Creation of facts, dimension tables and cubes for slicing and dicing of data.
• Work on Performance tuning and Optimization of ETL packages at Control Flow and Data Flow level along with making proper use of transactions and checkpoints.
• Communication with key stake holders, Client Sales Managers CSMs and end users in reference to business requirement and specifications for the latest dashboard reports and BI solutions.
• Creation and modifications of the fact and dimension tables in the star schema in accordance with the BI Data analytics and reporting solutions.
• Coordination of design and implementation of key dashboard reporting platforms based on social media, digital media and competitive data.
• Coordination of the on boarding of new clients onto the dashboard reporting platforms and managed their expectations.

Confidential

Senior Data Analyst/Developer

Project -- Depository Trust and Clearing Commission provides clearing, settlement and information services for equities, corporate and municipal bonds, government and mortgage-backed securities, money market instruments and over-the-counter derivatives. In addition, DTCC is a leading processor of mutual funds and insurance transactions, linking funds and carriers with their distribution networks.

Environment- Oracle 10g/11g, Sybase 12.x, SQL, PL/SQL, T-SQL, DB Artisan, SSIS, Rapid SQL, Sun Solaris, Oracle Mantas, Crystal Reports 11.0, SQL Server 2008, J2EE, Trillium, Advance Query Tool, Secure CRT, Erwin, Unix Shell Script, Sun Solaris.

Responsibilities --

• Development, support and maintenance of the key screening and monitoring applications in Anti Money Laundering unit at Depository Trust and Clearing Corporation DTCC , used for sanction screening and transaction monitoring in accordance with the Patriot Act and Bank Secrecy Act BSA .
• Involved in development and update of the Function specification and Technical specification documents in accordance with the latest business requirements and enhancements and regular discussions with the key stakeholders.
• Involved in analysis and audit of the data and documents from various units to ensure application integrity, accuracy, consistency and completeness from Anti Money Laundering AML guidelines perspective.
• Data profiling and data quality checkup on the data for multiple units to ensure it met the specified business rules and standards set within the organization.
• Document and summarize the findings in reports, specifying the corrective actions. Work on the detailed documentation of the KYC and customer due diligence CDD guidelines.
• Documentation of procedures to maintain and update multiple lists of designated people SDN etc. for the AML and compliance unit. Assisted in optimization of the matching process.
• Work on automation and updates of the list of suspect individuals and organizations, provided by Organization of Foreign Assets and Control OFAC , EU, World-Check etc.
• Conduct in-depth analysis of the matching logic and take steps for optimization and tuning of the process to determine the optimum threshold level, to minimize the false positives.
• Development and maintenance of complex SQL scripts, stored procedures, triggers, functions, indexes and other database objects to validate and load the data into the application.
• Performance tuning and optimization of queries, stored procedures, scripts and in-depth analysis of indexes and their tuning in order to improve the overall speed and efficiency of the system.
• Creation of scripts and process for dropping the data in staging tables and for cleansing and massaging the data prior to the next stage.
• Development and update of the ETL packages, tasks, workflows etc. and development of the multiple transformations to extract, transform and load data from various data sources like flat files, excel, CSV, MS Access etc.
• Monitoring and maintenance of the data extractions jobs, data feeds and overall workflows in the ETL process and troubleshooting issues related to that.
• Resolve AML related issues to ensure adoption of standards, guidelines in the organization. Resolution of day-to-day issues and worked with the users and testing team towards resolution of issues and fraud incident related tickets.
• Development of a Data Quality framework for monitoring of Data Quality and accuracy which had in built alerts for data discrepancy. In depth analysis for data fields and performed data cleansing, standardization and enrichment on the data.
• Enhancements to the NSCC Liquidity projects, purpose of which is to enhance the current Liquidity profile and to make liquidation adjustments to VaR Value At Risk and other coverage components.
• Conduct meetings with the users' point of contact, to collect requirements and to analyze and elaborate the requirements and expand them into a tentative design document.
• Conduct regular review of the Function and Technical Specifications to reflect the latest changes and enhancements.
• Manage the development team activity onshore as well as offshore in India, including daily monitoring, status reporting provide, technical guidance and mentorship.

Confidential

Senior Data Analyst/Business Analyst

Project The project involved development, support and maintenance of the key AML applications in Citigroup Global Anti Money Laundering Technology Unit, which are responsible for customer transaction AML screening operations, in order to keep Citigroup in compliance with Patriot Act, Bank Secrecy Act BSA and OCC anti-money laundering regulations. The project involved requirements definition, data analysis, scenario development and optimization of AML screening systems, with the goal of improving the overall accuracy and efficiency of the screening process.

Environment- Oracle 10g/11, MS SQL Server 2005/2008, Toad, SQL, PL/SQL, T-SQL, DTS, SSIS, SSRS, DataFlux, SAS, Business Objects, Mainframe, Sybase 12.x, SQL Navigator, SQL Profiler, Mantas, Actimize, MS Access 2007, Excel Macros, VBA, Crystal Reports 11.0, Windows Vista, Unix, Shells Scripts, Sun Solaris, J2EE

Responsibilities

• Support and development of the key anti money laundering applications for the sanction screening and transaction monitoring process, to ensure they are in compliance with the US Patriot Act and Bank Secrecy Act BSA
• Support and maintenance of key Anti Money Laundering AML applications, which manage data related to US Sanctions and Specially Designated Nationals SDN's from OFAC Office of Foreign Assets Control , USA Patriot Act 314 a and transaction screening process.
• Provide Business as Usual BAU support and Production support for the NESS application and perform data analysis. Provided training to the users as well as developers and bring them up to speed on different aspects of AML and Compliance.
• Designed the test cases, test scripts and coordination of testing activities for various NESS application releases. Co-ordination on regular basis, with off shore team to make sure smooth execution on testing, development and training front.
• Documentation of procedures for creation, analysis and maintenance of various Global, Local and Regional Lists.
• Involved in development and maintenance of Hot Lists and SDN Lists and as requested by OFAC Organization of Foreign Assets Control .
• Development, maintenance and replication of various Global, Local and Regional Lists of sanctioned people and entities, which helps Citi regional offices around the world, maintain strict standards in terms of financial transactions.
• Conducted research, assisted and provided information to support suspicious activity reports SAR and made recommendations. Worked on various aspects of AML, Fraud prevention, KYC, Brokerage and Trading Compliance.
• Define the review procedures for disposition of cases and identify the issues with data quality and accuracy and rectify it.
• Development and tuning of the Optimization Script in the database, in order to reduce the rate of the false positive hits generated by the system and streamlining the overall screening and filtering process and improve the overall performance.
• Development and tuning of the database script for performing the hit rate analysis of the list entries against the transaction files.
• Guided the automation of Gap Analysis process and preparation of Lists using MS Excel, Macros, MS Access, SQL and SAS.
• Obtained a wide selection of client documentation from internal and external data sources in order to extract key information and validate client's identity and reputation in order that they meet KYC checks
• In-depth Data quality analysis and Profiling of the input data, of the business units and new businesses within Citi Group, scheduled to come on board the AML applications, to assess issues with data quality, using DataFlux.
• Designed the framework for the DataFlux Architect and Data Flux Profiler jobs for the extraction of data from various data sources flat files, MS SQL Server, Oracle, Excel and COBOL Copybook files.
• Development and maintenance of a profiling report application in Crystal Reports in accordance with the GAML guidelines, which provides the details, frequency distribution and pattern analysis for all the data elements for various business sectors in Citi such as CitiFinancial, Citi Auto and FDR.
• Discussion of the Data Quality and profiling results with the key stakeholders and GAML and recommend the measures to rectify, fix and cleanse the data.
• Development of a reporting solution for data profiling, using DataFlux, MS SQL Server and reporting tools.
• Enhancements to the current applications to add complex functionalities as well as performance tuning and optimization of the application for better speed and matching accuracy, in view of addition of new business units and clients.

Confidential

Senior ETL Developer/Data Analyst

Project -- Harte-Hanks provides direct marketing services and end-to-end, value-added, information based solutions to the clients. This engagement involved multiple projects to develop and support Marketing-Campaign solutions for various regional banking clients Bank Atlantic, Central Pacific Banks etc that would help the clients target the right consumers for future marketing and advertisements.

Environment- MS SQL Server 2000/2005, Power Designer, DTS, SSIS, SSRS, Windows XP, Trillium, Rapid SQL, SQL Profiler, SSAS, Crystal Reports, Business Objects, VBA, TFS, Excel VBA, Excel Macros, MS Access, Windows NT server.

Responsibilities

• Involved in the development and maintenance of Business Intelligence solutions for data analysis and reporting of the demographical and business data of regional banks.
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services SSIS .
• Design, development and testing of SSIS packages, data flow transformations for the extraction, transformation and loading ETL of data from various data sources such as flat files, SQL Server, Access, CSV's etc.
• Creation and development of data flows and work flows for staging, manipulating and loading the data into the target data warehouse.
• Development of SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Used different Control Flow Tasks and Data flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Data Quality analysis and profiling of the input data. Design and development of data cleansing and standardization process for the customer demographical and marketing campaign data.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Develop reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• Develop Cubes using SQL Analysis Services SSAS and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Creation of various SQL and T-SQL stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Design and modification of the logical and physical data model in accordance with the updated business requirements. Creation of facts and dimension tables in the star schema model and cubes for drill-down and data analysis.
• Analysis and review of business requirement and approach for the proposed dashboard reporting and BI solutions with business analysts and key stakeholders.
• Created various ad-hoc SQL queries for customer reports, executive management reports, trend analysis reports and sub-reports.
• Debugging and resolution of execution errors using Data logs trace, statistics, error and by examining the source and target data.
• Testing and Debugging Stored Procedures, scripts and tuning of the ETL process. Monitoring and maintenance of data extractions processes and scripts.

Confidential

Senior Database Developer/DBA

Project Development and support for GCS Database system -- Global Card Services, Inc. GCS is the single source solution provider for any merchant accepting credit cards. They handle the authorization and settlement process for credit card transactions for various clients like Hilton, Marriott, Princess cruises, Seaborne cruises etc.

Environment- Sybase ASE 12.5/15.0, T-SQL, Sybase IQ, MS SQL Server 2000/2005, Power Designer, Sun Solaris, Unix, DB Artisan, Rapid SQL, Business Objects, Visual Basic, JSP, Windows NT server, Java Script.

Responsibilities

• Development of procedures and scripts according to the Visa K and TPS10 business specifications.
• Coding and maintenance of various Stored Procedures, triggers, tables, indexes etc. and troubleshooting database issues.
• Coordinated the setup and onboarding of new properties, Hotels Marriott, Hilton and cruise-ships Royal Caribbean, Princess etc. properties in the Bankswitch system
• Involved in Analysis and bug fixing for the Bankswitch application for GCS which interacts with Client and the bank software to provide authorizations and settlements.
• Development and maintenance of the daily/weekly tasks which archive the old data to the Sybase IQ data warehouse. Development of scripts in Sybase IQ to run periodic checks on the data.
• Performance tuning and optimization of Stored Procedures, queries and scripts, for better performance.
• Monitored and maintained data extractions processes and scripts.
• Made changes to various reports to make it more user-friendly and efficient.

Confidential

Senior Database Developer/Analyst

Project -- Development and support for FMRCO group

Environment- Sybase ASE 12.5, T-SQL, Power Designer, DTS, Sun Solaris, Unix, DB Artisan, Rapid SQL, Informatica Powercenter 7.1, Perl, Autosys , MS Project, DB2, Oracle 9i, Toad. Responsibilities

• Created and maintained Stored Procedures, Triggers, Tables, Indexes, Rules, etc. for the FMRCO application.
• Wrote and modified stored procedures for populating data and implemented procedures for displaying reports.
• Created and updated various simple and complex transformations Aggregator, Expression, Lookup, Joiner, Sequence Generator, Sorter, Stored Procedure, Update Strategy, etc., as part of Mapping between source and target.
• Creation of Sessions and executing them to load the data from the source system using Informatica Server Manager.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Involved in Production Support activities including monitoring loads, resolving exceptions and correcting data problems.
• Conducted performance tuning on stored procedures as well as well mapping and sessions to identify bottlenecks.

Confidential

Senior Software Developer

Project Worked on the development of the Netscape Browser 8.0 Promos project.

Environment- Sybase ASE 12.5, T-SQL, Power Designer, Sun Solaris, Unix, JSP, Java Scripting, XML, Crystal Reports 9.0, Crystal Enterprise 9.0, XUL, Html, DB Artisan, SSH FTP Client.

Responsibilities

• Worked on adding multiple components and functionalities to the Netscape Browser 8.0, using Java Scripting, XUL XML User Interface and Flash.
• Responsible for design development of various reusable components, reports, and back end stored procedures for data loads.
• Wrote and modified stored procedure and scripts with new business rules, for loading the data from different processors.
• Performance Tuning and optimizing of existing T SQL Stored Procedures, queries and scripts.
• Developing and integrating date reports, migrating older reporting systems to Crystal Reports.

Confidential

Senior Database Developer/Analyst

Project REFLEX Retirement Services and Investments is the core Client Server Application used by Mass Mutual to support its Retirement Services Business. The System is mainly developed in Sybase and SQL Windows. The Web Portal is developed using Microsoft Technology. Seibel is used for Customer Relationship Management. Most of the Business Logic resides on the backend.

Environment- Sybase ASE 12.5, MS SQL Server 2000, T-SQL, Power Designer, Sun Solaris, Unix, Codewright 7.5, Visual Source Safe, DTS, Unix , Sun Solaris, Windows 2000/NT/XP, Perl, VB.NET, Siebel, SCCS

Responsibilities

• Designing, implementing and monitoring various nightly loaders which trigger various jobs and stored procedures.
• Development, testing and enhancement of Mutual Fund Client Processing System in Sybase ASE database.
• Involved in Analysis, Bug Fixing and Enhancements for the Reflex database systems which interacts with .NET client as well interfaces with Siebel CRM and Campaign.
• Performance Tuning and optimizing of existing stored Procedures, queries and scripts.
• Resolved issues related to production and data fixes and tuning.
• Modified and worked on Perl data extraction scripts, which dump the data into the database.

Confidential

Senior Database Developer

Project The purpose of the AOPC project was centralization of the computer operations and data integration of the AOPC and the appellate courts. This involved data conversion and migration of data of over 100 counties to the central CPCMS system. The Common Pleas Criminal Case Management System CPCMS provides comprehensive case management and processing, including the production of forms, notices, reports, data enquiry, data transmission to various state agencies etc.

Environment- Sybase ASE 11.5/12.5, MS SQL Server 2000, T-SQL, Power Designer, Sun Solaris, Unix, DB Artisan, Visual Source Safe, Unix Shell Scripts, MS Access, Windows 2000/XP, VB .NET, J2EE, EJB , JDBC

Responsibilities

• Worked on the migration team to convert and migrate the data from over a 100 different counties in legacy systems and MS SQL Server, UDB, MS Access, Excel, Flatfiles into the main CPCMS system.
• Conducted multiple meetings with the end users and key stakeholders in different counties and document the current status of data and mapping of the data elements.
• Create a staging area and tables to extract data from different counties and dump them into the staging tables. Conducted data analysis, cleanup and standardization of the data using scripts to make them more homogenous.
• Wrote complex SQL and unix scripts, cursors, stored procedures, functions etc. to validate and finally move the data from the staging tables into the main system.
• Conducted review, validation and cross-check of the data after the move of the data in each phase to ensure accuracy and consistency of the data.
• Worked on a team of developers and with users to resolve data and performance issues in the main CPCMS Common Pleas Criminal Case Management System application.
• Designed, wrote and modified complex stored procedures views to validate, store and retrieve data. Wrote stored procedures called by jdbc interface.
• Wrote and revamped the logic code in the procedures views in the production environment for performance measurement and monitoring.
• Imported and Transformed data into SQL Database from different data sources using Microsoft DTS.

Confidential

Database Developer/Analyst

Project- Development maintenance of Crimson Database Medical System which was a Clinical Trial system, which collects medical data from different users and labs and accumulates it into a database on regular interval. Data processing, upload, download, data file transfer and etc., are handled by stored procedures and scripts. It included data extraction, report generation, feedback, and status update to the users by mail and data transfer.

Environment- Sybase ASE 10.x/11.x, T-SQL, Erwin, ,GQL, Sun Solaris, Embarcadero DB Artisan, MS Access, Visual Source Safe, Crystal Reports 7.0/8.0, MS Access, Unix, Windows 98/NT/2000

Responsibilities

• Formulate and define technical application scope and objectives. Coordinated with project team to identify and define required system modifications and enhancements to existing systems including changes to profiles, reports, screens, system design and documentation requirements.
• Full lifecycle development of modules like Hospitalizations Problem Charting, Serious Adverse Events, Research Blood Schedules from inception to the rollout, along with design, testing integration into the production system.
• Coordinated with different clinics and labs so as to design and modify the data model used ER-Win and schema, involved in developing and documenting business requirements converting high-level user requirements into functional specifications and similar deliverables.
• Gather and analyze the requirements of the Clinical Trial System the modules and develop the logical data flow structure for them.
• Wrote complex stored procedures functions using Transact-SQL to validate, store and retrieve data, in coordination with the team of developers. Wrote triggers to validate data and create reports to view data.

Confidential

Developer/Analyst

Environment- Windows NT, Oracle 7.3/8i, PL/SQL, Developer 2000 Forms Reports , Sun Solaris, Erwin, SQL Loader, SQL Plus, Toad.

Responsibilities

• Developed interface screen layouts for the application.
• Developed, tested executed the scripts for the Data Scrubbing and cleaning.
• Used procedures scripts to load data into staging tables in the Oracle Data Warehouse.
• Created Unix cron jobs to load flat files on periodic basis into Oracle database.
• Wrote queries to manipulate the data using SQL and SQL Plus and PL/SQL.
• Developed various PL/SQL procedures functions to populate validate the data and triggers to enforce the data integrity.
• Created Triggers and Alerts to make the application more user friendly and efficient.