SUMMARY:

• More than 10 years of progressive experience in Data Analysis, Data Management, Production Support and Business Intelligence in MIS/IT, Banking, Finance, Retail and Telecom industries.
• Solid understanding of statistical analysis, predictive analysis, machine learning, data mining, quantitative analytics, multivariate testing, and optimization algorithms
• Expert user of R, Python, Matlab and MS Excel including macros, graphs/ charts and pivot tables.
• Experienced with Word, PowerPoint, Access; Experience with BI tools such as Tableau, MicroStrategy
• Strong expertise on SQL; extracted, manipulated and retrieved data from relational databases with SQL; Adept in DW techniques and Data Management
• Solid understanding of Data Governance, Meta Data, Data Management and control; Adept in Data warehouse and Data mart architecture
• Experience in Agile development methodology and User interface designing pertaining to Database related tools
• Solid understanding of writing user stories and acceptance criteria, authoring and executing detailed test plans and test cases
• Passionate about new technologies; Creative and techno savvy professional, highly competitive, desire to learn new things, result oriented, detail oriented, quick learner with excellent analytical ability
• Strong background in data processing, data analysis with hands on experience in Excel, Access, UNIX and Windows Servers in High - Availability environments.
• Extensive experience in developing applications using PHP, Perl, SQLPlus, SQL, and Java and web applications using content management systems such as Joomla, Wordpress on Apache and Tomcat servers.
• Extensive experience in developing application using HTML, XML, JAVA, ASP.NET, C++, SOAP, CSS, TOAD, Rapid SQL,

WORK EXPERIENCE:

Confidential, Boston, MA

Data Management and BI Analyst

Responsibilities:

• Extract and analyze data from various sources using MS Access/ SQL, identification of defects/issues/gaps in the system, analysis of data and remediation of defect pertaining to entire Santander USA’s system processes; Develop issue management and resolution strategies, and coordinate activities to address data quality issues identified
• Used SAS and SQL on a regular basis for CCAR; trend analysis for Defects and Gaps
• Using Tableau and SAS, developed integrated Dashboards to track Data Quality Progress; submitted weekly, monthly/ adhoc reports for the management and internal use
• Worked closely with Data Management Architecture team and provided them detailed research support.
• Recommend and implement Data Framework, Data warehouse/ Mart and Data Management Strategy
• Establishing standards, processes and templates pertaining to documenting, analyzing and testing data
• Involve in development of new enterprise tool required for issue management and maintaining data quality
• Assisting in defining meta data and circulation among various groups within an organization

Confidential, Morrisville, NC

Business Data Analyst

Responsibilities:

• Data processing, analysis and reporting using Excel, Oracle, Sybase, Informatica, SAS, Cognos
• Trading application and ETL monitoring
• Define SLAs for deliverables and ensure delivery under SLAs
• Test, deploy, troubleshoot and rollback application and patches in PROD.
• Monitor, troubleshoot /escalate issue related to upstream and downstream flows and processes to assure smooth flow of trade data.
• Supporting database (SQL, Oracle, Sybase, MS-SQL, MySQL), software solutions and network technologies including TCP/IP, UNIX Shell/Pearl scripting and analyzing events and logs.
• Notify/Manage communications for all upstream/downstream delivery delays.
• Track version, production issue and maintain monitoring matrices
• Analyze logs, identifying root cause of production issues and incident management
• Maintain the SharePoint knowledge base.
• Ensure compliance with internal and regulatory requirements
• Prepare report for business, compliance and audit using documents, spreadsheet, SQLs and statistical analysis.
• Perform system health check and schedule cron jobs.
• Participate in DR test and disaster management activities
• Service and server migration
• Maintained the reporting system and trade reports on a daily basis.
• Interacted with internal user community to facilitate the information gathering on behalf of the development team
• Involved on developing ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Provided the required transformation logic using SQL.
• Supported various applications that provide auto provisioning of network elements on Confidential network.
• Worked with customers and third-party software vendors on file integrations and testing.
• Was responsible for remote Disaster Recovery systems and data backup and restoration.
• Moreover supported the Windows Active Directory and associated user support on front end Citrix Meta frame Terminal Servers.
• Involved on working closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Also involved in backend testing activity in both Windows and UNIX platform.
• Worked directly with senior programmers on all system enhancements implementations.
• Worked with project manager and sales on all large customer implementations and also worked directly with IT or EDI departments.

Confidential, Wilmington, DE

Production Support Analyst

Responsibilities:

• Maintained the Production Support notification system and manage issues on a daily basis.
• Interacted with internal user community to facilitate the information gathering on behalf of the development team
• Involved on developing ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Provided the required transformation logic using SQL.
• Supported various applications that provide auto provisioning of network elements on Confidential ’s network.
• Worked with customers and third-party software vendors on file integrations and testing.
• Developed Cron jobs for daily system health checks.
• Was responsible for remote Disaster Recovery systems and data backup and restoration.
• Moreover, supported the Windows Active Directory and associated user support on front end Citrix Meta frame Terminal Servers.
• Involved on working closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Was responsible for kernel, release upgrades and operating system patches. Managed network interfaces as well as Oracle database.
• Performed backend testing on UNIX platform.
• Worked directly with senior programmers on all system enhancements and customer implementations.
• Worked with project manager and sales on all large customer implementations and also worked directly with large retail chain’s IT or EDI departments.

Confidential, Richmond, Virginia

Data Analyst

Responsibilities:

• Team leader of Data Analysis and Credit Appraisal team
• Analyzed customer’s data for the identification of prospects using advanced excel and various BI tools such as Tableau, MicroStrategy, and reported to management
• Performed Quantitative Marketing Analysis and Predictive Analysis for entering into new segment in the Market, and recommended marketing strategy (Using data from various sources and quantitative tools such as statistical analysis, predictive analysis, complex macros, conditions and v-lookups for analysis)
• Recommended various financial products for bank by analyzing available customer data and presented to management by developing dashboards, more than 20 products implemented by Bank (Used multivariate testing, data mining, and optimization algorithms for analysis)
• Used available customer data for identification of location of new branch and recommended the same to the Confidential ; 6 new branches established based on my recommendation (Used
• Prepared credit proposals and presented to the sanctioning authority. Provided concise financial analysis by using advanced excel and Quantitative Risk management tools for working capital assessment for corporates, Greenfield/ Brownfield project appraisal and syndication for project loan
• Mentored 7 new hires; made them understand company business and culture quickly, which led to increase in productivity.
• Maintained database to provide dashboards and MIS reports to top management for efficient and effective decision making; Developed dashboards using Tableau and QuickView
• Worked closely with Data warehouse and Management team; Active member of User interface designing pertaining to Database related tools
• Wrote user stories and acceptance criteria for Database tools, authorized and executed detailed test plans and test cases
• Analyzed customer’s data for the identification of prospects, to understand their business needs, build client relationships and explored opportunities for cross-selling of financial products.
• Provided concise financial analysis using various financial modeling techniques (Using advanced Excel)
• Implemented complex project finance models using advanced excel, responsible for sanctioning 11 projects for long term borrowings

Confidential, Atlanta, GA

Production Support Analyst

Responsibilities:

• Managed quality review and developed and enforced production standards to ensure the integrity of processes and databases as well as the quality of output.
• Analyzed the source data coming from various data sources like Mainframe & Oracle.
• Reviewed all the systems design by assuring adherence to defined requirements.
• Coordinated with Dev, BA, QA, OPS teams and customers for resolution of issues within SLAs.
• Attained good understanding of agile and waterfall models.
• Communicated and introduced data standards, file communication discussions, customized functionality and testing information for new and existing customers.
• Involved in developing and executing Test Plans, Test Cases, Defect Status report, Requirement Traceability Matrix, and Script Status Report.
• Job responsibilities included troubleshooting of high severity issues.
• Participated in JAD Sessions periodically with Subject Matter Expert Confidential various phases of the Development Life Cycle to discuss open issues and resolve them.
• Overseen basic production support issues including file import errors, creations, and transfers, banking activities and EDI data

Confidential, Alpharetta, GA

Production Support Analyst

Responsibilities:

• Responsible for Web Order Entry Systems using Sybase, Oracle databases, which includes Production and IT operations
• Involved in backend and system testing.
• Reviewed Functional Requirement Documentation (FRD), Business Requirement document, System specification document and Use Case.
• Instrumental in setting up and implementing various Web Order Applications
• Monitored Client and Customer pager orders, resolving log errors and maintaining order status within the application
• Provided 7x24 operations and production support for Mobile and IPS billing systems, insuring successful link connections between remote customer servers and local application servers
• Monitored and resolved various application problems with Tibco and Kenan billing systems
• Successfully transmitted of daily and monthly usage files to external customers
• Provided a daily update with counts of all web order totals to the Sales and Marketing Departments
• Provided backup support for Daily and Monthly usage feeds to external companies
• Maintained all new production support projects, tasks and updated operational procedures and production support documentation.